B
Bubu85238
Hi,
I am trying to open a form in Access 2003, based on the criteria selected in
another form.
Here are my TABLES and fields:
SEARCH: date, time (all text fields)
TIMESLOTS: id, date, time (all text fields)
Here are the FORMS and fields:
SEARCH: date, time
SEARCH RESULTS: id, date, time
What I would like to do is open the SEARCH form and select a date, module,
and time; then press a button to open the SEARCH RESULTS form displaying only
the records that meet the criteria selected in the SEARCH form.
I have tried using a query and building the SEARCH RESULTS form from the
query, where the query included conditions on the date and time fields to
select the records that match the date and time fields from the SEARCH form.
Although I dont get an error when I use a button to open the form; I get no
results. If I open the form by opening it directly I get a pop ups asking me
to enter the date and the time and then I do get valid records in the SEARCH
RESULTS form.
What can I do to get the form to open with valid records using a button?
Thanks in advance for the help.
I am trying to open a form in Access 2003, based on the criteria selected in
another form.
Here are my TABLES and fields:
SEARCH: date, time (all text fields)
TIMESLOTS: id, date, time (all text fields)
Here are the FORMS and fields:
SEARCH: date, time
SEARCH RESULTS: id, date, time
What I would like to do is open the SEARCH form and select a date, module,
and time; then press a button to open the SEARCH RESULTS form displaying only
the records that meet the criteria selected in the SEARCH form.
I have tried using a query and building the SEARCH RESULTS form from the
query, where the query included conditions on the date and time fields to
select the records that match the date and time fields from the SEARCH form.
Although I dont get an error when I use a button to open the form; I get no
results. If I open the form by opening it directly I get a pop ups asking me
to enter the date and the time and then I do get valid records in the SEARCH
RESULTS form.
What can I do to get the form to open with valid records using a button?
Thanks in advance for the help.