T
Tom
The sample database form allows me to search any table I select and then
select criteria from all fields. Once all selections have been made, the
create query button is selected and all hits are displayed in a table format.
You may then use the created query to fill a form, but must got through this
process for each search.
Problem: I would like help with automating this search form. Instead of
building a query each time I would like the create query button to
automatically run that query and display the results in my existing form. I'm
trying to automate the process for users so that they don't have to go
through the steps each time. I'm looking for help with the SQL in modifying
the process to display all hits in my form for ease of interpreting data in
the selected records.
I can provide the sample database and my form if it would be helpful.
select criteria from all fields. Once all selections have been made, the
create query button is selected and all hits are displayed in a table format.
You may then use the created query to fill a form, but must got through this
process for each search.
Problem: I would like help with automating this search form. Instead of
building a query each time I would like the create query button to
automatically run that query and display the results in my existing form. I'm
trying to automate the process for users so that they don't have to go
through the steps each time. I'm looking for help with the SQL in modifying
the process to display all hits in my form for ease of interpreting data in
the selected records.
I can provide the sample database and my form if it would be helpful.