Save database from Visual Basic

[TDN169]

Please help! I need to get either VBA code or a macro to simply:

1. Save the database (what you get with CTRL+S)
2. Open a table.

I can't do either of them.

 

[NigelShaw]

wouldn't you be better opening a table through a form? Afterall that's what they are for. What do you mean by save database? When you edit a record, it's already saved. You could try docmd.save

 

[TDN169]

This is from a form- sorry I forgot to explain that one.
basically, I need to update the lookup list before I open the table as the form edits the lookup list in the table. The best way is to save the Access database.

Hope you can help!

 

[NigelShaw]

Hi,

a little confused so would advise to be clear when looking for help as everyone here might not have much time and could probably do without having to decipher a question first as it would most likely be dismissed.

Now

if i am understanding this right, you have a form that is holding information. a user will update the information and you want to save it to a table?

NS