Relating Forms with a command button

[Therese]

I have a general form, frmInfo, on this form are several different distinct areas of information. For example, the first part of this form is dealing with case information that includes officer name which is a lookup list. If the officer is not in the list I have a command button to open a second form to add the officer info in the officer form. However, I have two questions. 1) when I go back to frmInfo, I have to go up and hit Record- Refresh for the new officer name to appear in the drop down list. Is there a way to automate this. or better yet 2) Is there a way to automatically link that record so after I enter the info in the officer form, when I close that form the information will appear in the frmInfo. I think the second question is pushing it. I would be happy to figure out the first problem. Thank you for any help you can give.

 

[Pauldohert]

On save of the new officer record or on close of the officer form - requery the combo box on the info form

Form_frminfo!officer.requery


to get the value into this field

also in the officer form put

Form_frminfo!officer = Me.ID (Id of the officer you added)

 

[Therese]

Thank you for your help. This forum is really a big help!!!!