Filter records in form ON OPEN command

Joined
Jul 12, 2007
Messages
45
Reaction score
0
Greetings Databasers! :)

I wish to open a form that 'on open' filters the records. There are two records that needs to be filtered, these are; SchedDateTime=Mon 9-11 and AssignedTo=Fred.
I presume it needs to be done in VB, unless there is another way. The Data is stored in a query called Schedule Query.
I would like to know the formula to filter these fields.

Thankyou
MCB
 

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


Top