Automatically saving records in real time

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

Help!!
How do I get Access to automatically save the record I
just input into my form so that I can IMMEDIATELY click on
my print command button?

Here's how I've got it set up:
One OrderID can have lots of order details. An Order is
its own table, and the OrderDetails have their own table,
with enforced referential integrity tying them to the
OrderID field.

The OrderID table is set up as the main form, and the
OrderDetail table is set up as the subform. So in one
OrderID record, I start entering new data for the
OrderDetailID. On the next record, I enter more new
OrderDetailID data for the same existing OrderID.

When I hit my Print command button, the macro is supposed
to print the entire orderID with ALL the OrderDetailIDs,
but it will only print the DetailIDs for the parts where
I've tabbed out of the rows (or clicked in fields in the
new row) with only limited information from the final
OrderDetailID record.

I tried adding a save button, where the combo button
wizard gave me the "Save Record" selection, but if I
finish inputting my data, then hit the "save" button, then
hit my Print command button, I still get only partial data
for that last OrderDetailID in my report.

I also tried inserting a line in my macro to save the data
before the OpenReport action, but I still get the same
problem.

Any recommendations?
Thanks in advance,
Helen
 
Helen said:
Help!!
How do I get Access to automatically save the record I
just input into my form so that I can IMMEDIATELY click on
my print command button?
Click to expand...

Add a line to the code for your print button (at the top)

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