Auto Update inputed data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all,

I have a form that I use for my company orders, the form has approimately
15 fields and I would like the form / table assicated with the form to be
updated after each field is entered... First is this possible, second how
would I do it?

Thanks,

Brook
 
good day all,

I have a form that I use for my company orders, the form has approimately
15 fields and I would like the form / table assicated with the form to be
updated after each field is entered... First is this possible, second how
would I do it?
Click to expand...

Well, you *could* put code in each form control's AfterUpdate event:

Private Sub controlname_AfterUpdate()
Me.Dirty = False
End Sub

to force a write to disk.

But why? What's the point of having partially complete records stored?
Are you accepting the fact that this would make it impossible to have
any Required fields (other than the first control entered), since
you're saving the record before all the controls are filled?

John W. Vinson[MVP]
 
I guess what I meant to say / wanna do is "autoupdate" after my last field is
entered.

Brook
 
I guess what I meant to say / do was autoupdate after my last field is updated.

The reason being is that I have an order form that I print that I want to
make sure contains all my updated fields.

Thanks,

Brook
 
I guess what I meant to say / do was autoupdate after my last field is updated.

The reason being is that I have an order form that I print that I want to
make sure contains all my updated fields.
Click to expand...

Access automatically saves the record to disk ("updates" in your
terminology) when you close the form, move off the current record,
move to any control in a Subform, etc. etc.

If you have a command button on the Form to open the Report which
prints the order form, just include a line in its Command Procedure
VBA code:

If Me.Dirty Then Me.Dirty = False

to explicitly save the record. Put it before the OpenReport line.

John W. Vinson[MVP]
 
Back
Top