Save problem

  • Thread starter Zaradi Zakaria via AccessMonster.com
  • Start date
Z

Zaradi Zakaria via AccessMonster.com

Hi,

I just created one command button to assign a few task;

On Error GoTo Err_Command23_Click

Me!DateUpdated = Now()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub

User choose some particular value(Name) at combobox (using SELECT DISTINCT
and Control Source to a query) and click that command button, DateUpdated
field should update latest date and then save. It works fine, but I just
curious when a few data came out there're missing with value (Name) or
DateUpdate. If user just choose value at combo box is there anyhow Access
still save it without click command button? And is there any difference to
save with:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

vs- only DoCmd.Save?

Which one is more secured?
 
Z

Zaradi Zakaria via AccessMonster.com

Well you do not need to answer my question, I just figure out how it works by
my observation, any whre it just a curiosity. Well you all did reply last
time, thanks for that. ... How the christmas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top