how do I force writing the data to a table?

  • Follow


I've got a form bound to query - an updatable one. Now when the user
clicks 'SAVE' I need to force saving the data to a table it's bound to
so that I can open a new recordset with updated values - before I
close the form.

Thanks,
Morris
0
Reply Morris 2/11/2008 3:01:53 PM

Take your pick:
    Me.Dirty = False
    RunCommand acCmdSaveRecord
    Me.Refresh

Use error handling in case the record cannot be saved (e.g. required field 
missing.)

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Morris" <maurycy.s@orange.pl> wrote in message
news:875eda0b-c301-462b-b36b-daa3d65c4d48@s13g2000prd.googlegroups.com...
> I've got a form bound to query - an updatable one. Now when the user
> clicks 'SAVE' I need to force saving the data to a table it's bound to
> so that I can open a new recordset with updated values - before I
> close the form.
>
> Thanks,
> Morris 

0
Reply Allen 2/11/2008 3:29:19 PM


1 Replies
284 Views

(page loaded in 2.698 seconds)

Similiar Articles:
















7/27/2012 4:38:55 PM


Reply: