A
Andy
Hi Everyone,
I am very new to this but so far have managed to create a small database
with a few tables linked together and a few queries.
I have also created some reports and forms.
Using the switch board I would like to open a form in edit mode, which has
been filtered by default
base on the following two conditions:
- Status = Open
- Trace date = Any date during this week. Basically I would like the date
range to change automatically depending on the current week. The current
week being Monday to Sunday.
What is the code and where do I enter it?
I am using Access 2000.
Many thanks
Anguel.
I am very new to this but so far have managed to create a small database
with a few tables linked together and a few queries.
I have also created some reports and forms.
Using the switch board I would like to open a form in edit mode, which has
been filtered by default
base on the following two conditions:
- Status = Open
- Trace date = Any date during this week. Basically I would like the date
range to change automatically depending on the current week. The current
week being Monday to Sunday.
What is the code and where do I enter it?
I am using Access 2000.
Many thanks
Anguel.