Access 2007 - Form Problem

[Ady]

Hi There

I am not an expert in access so please be patient.

I am building a simple contact database on Access 2007. I have a contact
form where the user enters all of the address details ect. Before they do
this there is another form where they enter a name. The contact form then
has a drop down selection in with all of the names that have been entered in
the "name" form.

However I notice that if I have both forms open together, the name entered
in the "name" form does not populate the name in the drop down box on the
contact form if they are both open together. I have to close the contact
form and re-open it again before the new name is in the drop down list..

Is there a method to either refresh of populate the data without closing the
contact form and then re-opening?

Any help or advise offered is most appreciated.

Kind Regards

Adrian

 

[ruralguy via AccessMonster.com]

Records are not saved until you move to another record or close the form. You
can put DoCmd.RunCommand acCmdSaveRecord in the AfterUpdate event of the
control to save the record after you have entered the name if you want.

 

[Ady]

Many thanks for this. I shall investigate further.

Adrian