form events

R

richaluft

can anyone tell me
1) in which event a Filter that is placed in the form property sheet
(eg- Filter = SQL statement) would take place?
2) If I use a RunCmd Recordsgotonew in an event on a form, to where
does this place the already-open form in the sequence of 'opening'
events for the form?
Thanks in advance.
R
 
A

Allen Browne

For your 2nd question, it's probably best to use the form's Load event.

You can use the Open event, but this can have side effects such as
triggering other events in a different order than normal, or even multiple
times (in some versions.)
 

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

Which event? 5
Managing Sequence numbers between 3 sub forms on 3 tabs populated bythe same table 1
remove a filter 5
Automation by not storing calulated variables 5
Access 2007 Open forms with FilterOn and form fails to open 5
OpenForm vs. Form menu double click. 3
filling unbound form 1
form objects lose association with VBA code.. 2

Top