How quickly does a Form record update?

[JRINC]

I am designing a way to print pre-selected addresses on mailing labels.



Admin opens Form and chooses labels by clicking in a yes/no box. Then opens a Report designed to print the labels. The Report opens in preview mode. I have noticed that you have to save the Form after checking the boxes or the changes will not show up in the label sheet preview.

Is this normal? Or is there a lag? I thought Access saved changes almost immediately. Any solutions?

[boblarson]

Access only saves if you exit the record (by closing or moving to another record) or explicitly save. So, you would need to include this in the After Update of the checkboxes to make it immediate:

Me.Dirty = False

[JRINC]

Error: Access cannot find the object 'Me.'

Added Me.Dirty = False to AfterUpate on Form (check box settings)

[boblarson]

Error: Access cannot find the object 'Me.'

Added Me.Dirty = False to AfterUpate on Form (check box settings)

You added it to the wrong place. It doesn't go in the event property of the properties dialog, it goes in the VBA window.

See here for an example:
http://www.btabdevelopment.com/ts/eventcode