Form & Queries

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

Access 2003

I would like to use a form to return query results. I am using a form now
to input data into a table. The form has several Combo boxes that have
record sources from both tables and list values.

I would like to be able to use the same form as a query. When I select data
from on or more of the combo boxes I would like to run the query and have it
return the results. I can do this by using filters on the input form but it
is very time consuming.

I have looked in help and have not been able to find anything that has been
of help.

Thanks
Robert M. Raley
 
Robert,

Use the syntax

=Forms!<formname>!<controlname>

in the criteria cell of the query, replacing <formname> and <controlname>
with the correct values from your form.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Thanks again Rebecca, Two times in one day you saved my butt.

I will try this and hope for the best.

Bob Raley
 
Back
Top