C
Connie
It is likely a sorting issue. There is a lot of
flexibility to creating a query that brings in the proper
fields. You can then sort by it last name and do other
stuff like eliminated records that you don't want
included in your combo box.
Next, in the row source of the combo box's properties,
bring in the query. Check out other properties like the
column widths, your bound colunm etc to make sure it does
what you want it to do.
Connie
matches both the LastName and FirstName. Right now it is
only going to the first lastname that matches. Please
help!
flexibility to creating a query that brings in the proper
fields. You can then sort by it last name and do other
stuff like eliminated records that you don't want
included in your combo box.
Next, in the row source of the combo box's properties,
bring in the query. Check out other properties like the
column widths, your bound colunm etc to make sure it does
what you want it to do.
Connie
and "FirstName" and I want it too find a record that-----Original Message-----
I have a combo box on my form with "LastName"
matches both the LastName and FirstName. Right now it is
only going to the first lastname that matches. Please
help!