Creating a Query from a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to design a form that will allow my employees to view their completed
assignements. I since I know the employee names (only 3 right now) I have
already created 3 queries that will display the desired info for each
employee.

I want to employees to open the form and select their name from a combo-box
or list box. Upon doing so, a query will run and display the completed
assignments for that particular employee.

Is this possible and if so, how do I do it?
 
HL said:
Hi,

I want to design a form that will allow my employees to view their
completed assignements. I since I know the employee names (only 3
right now) I have already created 3 queries that will display the
desired info for each employee.

I want to employees to open the form and select their name from a
combo-box or list box. Upon doing so, a query will run and display
the completed assignments for that particular employee.

Is this possible and if so, how do I do it?
Click to expand...

Look at one of your existing queries. Your criteria for a specific name would
be replaced with...

Forms!NameOfForm!NameOfComboBox
 
Rick,

Thanks for the advice. It worked!. I just have one more question. When
the user selects his/her name from the combo box, how do I get the query to
display on the screen?
 
Back
Top