Saving an Entry

[e2cheng]

i'm trying to a record to a file.

i have a form that is run off a query. on this form, i have a bunch of unbound textboxes which i retreive info from. user enters a bunch of stuff into these boxes. then i take info from th4ese boxes feed them into respective field, then i want to save. so i do this:

docmd.save

then immediately access that information from another form that pops up with the info run from the same query. however, i'm always missing the last entry. anyone know why??

thank you for your help!

 

[casey]

from one of the great Access Minds on this site (not me, of course).

Try DoCmd.RunCommand acCmdSaveRecord

This should save the record that you entered.

I believe the command you have...
docmd.save
...actually saves the form.

 

[e2cheng]

Thank you!!

thank you so much for getting back to me on that. you not only solved my one problem, but another issue that stemmed out of that one.. your two lines saved me much much more grief..

most grateful,
eric