Likely, you have not done anything to save the record entered in the first
(bound) form. The record is saved when you explicitly save it (menu item or
function key), when you move off the record to a different one, or when you
close the form. Perhaps if you include a DoCmd.RunCommand acCmdSaveRecord
before the DoCmd.OpenForm.
Larry Linson
Microsoft Access MVP
"Chang Zhu" <cz**@changbioscience.com> wrote in message
news:5a**************************@posting.google.c om...
I use forms to enter data. Once data is entered in the first form, I
save it and then open the second form. Parts of the data for the
second form (such as id, name) will come from the first form.
Strangely, if I open the second form, and enter id it will not bring
up the name. But if I then close the second form and reopen it, both
id and name will appear. What could be the problem? Your help will be
greatly appreciated.
Chang