REFRESHING DATA

[athai]

Hi All,

This may be a simple question, but I am not an experienced Access/VBA person...at the moment I have tab, with the first tab as "Main_Menu". It has an unbound list box, and displays all entries. A command button has been created to add new record on this main menu, which takes you to a form which users enter data.

My question is...is there a way to create a command button in the data entry form which will on click:
1. Take you back to the main menu: and
2. if users have entered data, refresh immediately the list box.

At the moment, i have to exit hte database to refresh.

Thanks a million!

 

[Rohdem]

This should work

Private Sub button1_Click()
'make sure the new record is saved
docmd.runcommand accmdsaverecord
forms!mainformname!comboboxname.requery
DoCmd.close
End Sub


Mike Rohde
rohdem@marshallengines.com

 

[athai]

Thank you very much Mike, It worked!!!