linking forms by an ID field

[Jeff @ CI]

I am setting up a database in Access 2000. I provide the user a form listing
a roster of names. I provide a button to allow them to open a form and am
able to pass an ID number to the new form. This form is a menu of options to
open yet another form. I tried to pass the id to a third form, but cannot
get it pull the correct data into the third form based on the third form. I
used the wizard to make the form and to attempt the link.

Any ideas?

Thanks

 

[bhicks11 via AccessMonster.com]

Is form one still open? Try referencing the ID from form 1 if it is still
open. You can also make sure you are seeing the ID on form 2 by putting a
temporary control.

Bonnie

http://www.dataplus-svc.com