Hi, I have field "date" in a mainform based on table "dates" on that main form I have a subform based on table "daysofweek" with field "monday". I want to put a button on main form that using VBA searches all the records in table "daysofweek" ( not just the one showing in the subform ) for a match between "date" and "monday".
Now I know there are other ways of achieving this such as a combobox or whatever but I want to learn this function so I can use it elsewhere as well. Any help would be greatly appreaciated!
Thanks,
Raif
[email protected]

First, change the name of your variable. The word "Date" is a reserved keyword in Access. There is a function called Date() that gives you todays date (or actually, the date your computer is set for... presumably, today). Change it to something unique, e.g. dtmDate.

The function that tells you the day of the week of a date is Weekday. Search help on Weekday to see how it works.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division