me.refresh / me.requery in a continuous form causes access to quit

J

JulieD

running Access 2000 SP3 i have an OK button on a continuous form that is
designed to allow the users to check their input - by the use of a snapshot
of a report in another form, if the input is correct they can confirm this
and then posting to three tables is undertaken. The code worked fine until
i introduced the viewing of the snapshot report and rearranged some of the
code, now the me.refresh / me.requery lines in the code causes access to
quit with no messages or anything.

AFAIK i need one (or both) of these lines to cause the continuous form to
display all records for the current date - if i comment them out the code
works but i don't get all the records for the day.

any ideas welcome

Cheers
JulieD
 

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

Top