How to Update Table with out leaving form

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

Hi all, What I am tring to do it V.simple but I'm
finding it V.hard.

I have a form that is bound to a table .
It has a control that creates for me an worddoc and
preloads specific details based on data on the form.

My problem is this... When I add new data to the form I
need to be able to press my button that reuns a query on
multiple tables to pull the information I need. BUT i
cannot do this because the data held in the form has not
yet been delivered to teh table.

So I need Despately a way of telling a form .. Deliver
data to table now! ..

Any Ideas Greatly appreciated.

Cheers Russ
 
So I need Despately a way of telling a form .. Deliver
data to table now! ..
Click to expand...

Two ways, both a bit obscure and hard to find in the online help!

Either;

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty = True Then Me.Dirty = False
 
cheers Guys worked like a gream

-----Original Message-----


Two ways, both a bit obscure and hard to find in the online help!

Either;

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty = True Then Me.Dirty = False



.
Click to expand...
 
Back
Top