Access help :(

[rpeare]

Access does not like spaces or special characters in object names (forms, queries, field names, table names etc)

your syntax would be

forms![on call]![startdate]

[dslegends]

Ok so i have this up and running now using these criteria, but a dialog box prompts me to enter the data i want is there anyway to make it display automatically just those for for a certain day with out haveing to enter what day it is like for today i only want it to display the people that are oncal for just today and no one else and then once tomorrow hits it only displays the people on call for tomorrow. without having to enter the days date . and i also get a Action Failed when i hit the button after typing in the persongroup

Between [forms]![On Call]![StartDate] And [forms]![On Call]![EndDate]
Between [forms]![On Call]![StartDate] And [forms]![On Call]![EndDate]
[forms]![On Call]![StartDate]
[forms]![On Call]![EndDate]

[dslegends]

Ok now when I put that code in there it just displays 4 people from completely different workgroups and the DBlist continues to pop up when i hit the search button

[rpeare]

On your search form have an unbound text box that has the control source of = date()

it should populate with the current day's date whenever you open it then use the same type of criteria you did for the first query except instead of being between to values you would have it = the text box that has today's date in it.