Updating a table after closing a form.

[Guest]

I need to update a table in a database I am creating. When a user doesn't
find the name in a lookup combo box, they click a command button and another
form appears to allow them to add a new account. Once the second box is
closed I need to update the table they just entered the account so it can be
added to the job. I thought that I would use the Me.Refesh in the code window
under the On Close, but that didn't work. Any assistance would be greatly
appreciated. If you can't already tell Access is not really my forte.

 

[Guest]

Try and use requery instead of refresh, on the unload event of the second
form enter the code

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Forms![FirstFormName]![ComboName].requery

 

[Guest]

This command for the requery looks as though it only updates one object,
multiple objects are added with the form that opens from the command button.
Can I do Tables![FirstTableName].requery ?

Try and use requery instead of refresh, on the unload event of the second
form enter the code

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Forms![FirstFormName]![ComboName].requery
--
In God We Trust - Everything Else We Test

I need to update a table in a database I am creating. When a user doesn't
find the name in a lookup combo box, they click a command button and another
form appears to allow them to add a new account. Once the second box is
closed I need to update the table they just entered the account so it can be
added to the job. I thought that I would use the Me.Refesh in the code window
under the On Close, but that didn't work. Any assistance would be greatly
appreciated. If you can't already tell Access is not really my forte.

 

[Guest]

After performing a requery on the combo box, will allow the user to select
the name he couldn't find before, and to select it.
--
In God We Trust - Everything Else We Test

This command for the requery looks as though it only updates one object,
multiple objects are added with the form that opens from the command button.
Can I do Tables![FirstTableName].requery ?

Try and use requery instead of refresh, on the unload event of the second
form enter the code

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Forms![FirstFormName]![ComboName].requery
--
In God We Trust - Everything Else We Test

I need to update a table in a database I am creating. When a user doesn't
find the name in a lookup combo box, they click a command button and another
form appears to allow them to add a new account. Once the second box is
closed I need to update the table they just entered the account so it can be
added to the job. I thought that I would use the Me.Refesh in the code window
under the On Close, but that didn't work. Any assistance would be greatly
appreciated. If you can't already tell Access is not really my forte.