P
PB
I have a form to add records to a table. When the record is added, a macro
runs, to open another form (based on a query) which checks a balance - this
should include the record just added. If the balance is over a certain
amount, the user should get a msgbox, etc.
If I add one record that puts the balance over a certain amount, this works,
and the user gets the msg box.
If I add one record - which doesn't put the balance over the amount, then
add another record which does....the msgbox doesn't display after adding the
second record.
If I run the query manually - it doesn't include the second record. If I
close the query and run the query again...the second record finally appears.
Why is this second record, not included in the query immediately?
The macro saves the record before opening the form to check the balance...so
I don't understand why the second record isn't immediately included in the
query.
HELP! I'm fairly new to Access.
PB
runs, to open another form (based on a query) which checks a balance - this
should include the record just added. If the balance is over a certain
amount, the user should get a msgbox, etc.
If I add one record that puts the balance over a certain amount, this works,
and the user gets the msg box.
If I add one record - which doesn't put the balance over the amount, then
add another record which does....the msgbox doesn't display after adding the
second record.
If I run the query manually - it doesn't include the second record. If I
close the query and run the query again...the second record finally appears.
Why is this second record, not included in the query immediately?
The macro saves the record before opening the form to check the balance...so
I don't understand why the second record isn't immediately included in the
query.
HELP! I'm fairly new to Access.
PB