Run a query from a form

E

Erik

I am new to Access and I have been working on an Employee Database.
I have created a query that contains the employee names and certain
information, where the first and last names are parameters.

I have also created a form that gets information from a seperate table. What
I want to do is to use the first and last name that was entered in the text
boxes as my parameters for the query. Then on another tab I have a list box
where I would like to display the information for that employee from the
query.

Is there any simple solution? I hope I was clear enough.

Thanks in advance
 
T

taylormade

What I found most useful is displaying your query in a 'subform' . There is
a tool for doing that. basically it is a form on top of your existing form
You'll have to have this subform displayed in "datasheet view"...but that
will also make it easy for you to display a lot of data about your employees
at one time.

Using these subforms is a great way to display things like "employee detail"
or "item detail" when some of that detail is not needed very often.
 
E

Erik

Thanks.

Is there a way to view it as a form? It let me create the form but it will
only view in that "Datasheet view"?
 
T

taylormade

If you click on the left top corner of the subform you can right click and
select "properties" (for the form)

from here you can change the default view form datasheet view to continuous
view.
 
2

28

taylormade said:
If you click on the left top corner of the subform you can right click and
select "properties" (for the form)

from here you can change the default view form datasheet view to continuous
view.
Click to expand...
 
Top