Force field to save to prevent crash

S

Sammie

Access crashes if a user enters data in a field, and without leaving the
field, presses a command button to print a report based on the form. How can
I force Access to save the data in the recent field before proceeding to
print the report?
 
K

Klatuu

In the command button code, before you print the report:

If me.Dirty Then
Me.Dirty = False
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Dynamic Naming of Form Button 3
Copy previous record into form field 0
Save workbook without shapes 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Data Entry VBA 4
Data entry for a table from a form 1

Top