Button to open form and find specific data to display

[CEV]

I have a form with several fields on it from the Employee table, one of which is EmployeeNumber. I am trying to create a button via the Command Button Wizard. This button will open another form (Training) with several fields, one of which is EmployeeNumber, on it from the Training table. Both tables have EmployeeNumber field and are linked together via this field. In the wizard I select "Open the form and find specific data to display". I do this because I want to display the employee training info for the employee that is displayed on the first form. I click on next and your supposed to select the matching fields from the two forms. The frmEmployees is showing no fields listed and the frmTraining is showing all the fields on that form as it should.

I cannot figure out why the fields are not showing up in the Command Button Wizard for the frmEmployees.

If you can let me know why and how to fix this, I would greatly appreciate it.

Thanks

[pbaldy]

Not sure why the wizard isn't showing the fields, but this is the type of code it would produce:

BaldyWeb wherecondition

[CEV]

Have not ever done anything by manually entering code. Not sure of the exact steps for that.

A couple of things to note, and not sure if it makes a difference or not. But the database was originally created in Access 2003. I opened a copy of it on another computer using Access 2003 and I am able to create the button as the fields are showing up like they should. I also opened it with Access 2007 on that computer to see if it was a specific computer issue. 2007 did the same thing with not showing the fields available in the Command Button Wizard. Any ideals? Oh, and the other computer is running WinXP.

[pbaldy]

Here's how to enter the code:

http://www.baldyweb.com/FirstVBA.htm

[CEV]

Thank You very much!!!! I will give this a try.

[pbaldy]

No problem, and welcome to the site by the way!