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.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<richaluft[ at ]cs.com> wrote in message
news:f5340672-48dd-453f-a347-e40150e393ff[ at ]20g2000yqt.googlegroups.com...
[Quoted Text] > 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
|