filter records in form by 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
 
Back
Top