Update query always misses off last record (1 Viewer)

Revdjembo

New member
Local time
Today, 10:11
Joined
Nov 21, 2018
Messages
4
Hi all,
I have a class registration database updated after each event by an update query. Each person present is ticked off using a check box and the query run. Without fail the query always misses off the last record. Why?
My work around is to have a person called Dummy Dummy at the end of the class list which is always the last name on the register. Is there a better solution?
Thanks for your help.
 

isladogs

MVP / VIP
Local time
Today, 10:11
Joined
Jan 14, 2017
Messages
18,186
If the cursor is on the last record it won't have been saved so will be omitted from your update query.
Set the focus to another object before running the query. For example run it from a command button. Or explicitly save the record before the query runs
 

June7

AWF VIP
Local time
Today, 02:11
Joined
Mar 9, 2014
Messages
5,425
I assume checkbox is bound to field. Possibly because the edit has not been committed to table when query runs.
 

Users who are viewing this thread

Top Bottom