Combo Box order

  • Thread starter Thread starter Milynda
  • Start date Start date
M

Milynda

My question and problem is this:

I have a created a combo box that will look up a record
and "pull up" that record. (Side note, the records are
employee records) I have multiple records for the
employees or some that do not require employees. Is
there anyway to for the combo box to only use the fields
that have data in them and then no repeat the data in the
combo box?

Also, can I connect the records so that one will identify
the rest and bring them up?
 
In the query that is the Row Source for the combo box, you can designate how
to select the records (ignore ones with no value in one or more fields, sort
in specific orders, not repeat values that are in more than one record,
etc.).

Please provide a bit more info about your table and the fields so that we
can give you a more direct suggestion for your setup.
 
Further information

A employee may have more than one recorded associated
with them. (i.e. an employee may have three actions
against them, each generating a different entry) My
intention was to have the records connected but I do not
how to do so so I created a combo box to look up the
records an pull them up. What I would like to have
happen is that when I pull up one record associated with
the employee, that I would get all three records.
 
I am a bit confused. Your original post said that you want to show an
employee only once in the combo box, but this reply suggests that you want
to see the employee the same number of times that there are records for that
employee?

Let me start with the first approach. Your row souce SQL should look
something like this (Substitute your real names for my generic names):

SELECT EmployeeID, EmployeeName
FROM TableName
WHERE EmployeeID Is Not Null
GROUP BY EmployeeID;

Set up the combo box to have 2 columns, with column 1 being the bound
column, and the first column not being visible. This will allow you to show
the employee name in the combo box, and then, when you select the name you
want, the EmployeeID value is available to be the linking value to
displaying the matching records.
 
Back
Top