If you are using two different combo boxes to select last name and first name, and you are populating those boxes from the last name and first name fields, you may not get the results you would expect.
record 1: last name = doe, first name = john
record 2: last name = smith, first name = harry
Your last name combo will have doe and smith as selections and your first name combo will have john and harry as selections. If you not base the contents of the fisrtname combo on the results of the lastname combo you could end up with someone named harry doe or john smith.
I have a form with some combo boxes
The form is based on a table
One field is lastname and one is firstname
The row source is based on table/query
The lastname field works fine but the firstname brings in the lastnames
What am I doing wrong
Hi wdisneymom and "Welcome to the Forum"
First, why are you using two separate ComboBoxes to bring in the person's name? You can just use one ComboBox, have it to look up the names for you listed in order by either First or Last name, and when you select the one you wish, be it one or the other, once selected, the other name fills in another TextBox. At least it seems that's where you're trying to get to. Select a name from a ComboBox and reveal both First and Last names. Is that correct? Could you possibly make a Copy of your database, remove sensitive data/names and replace with dummy data, ZIP it down with WinZip or something, and Post it here for someone to analyze for you? Then, they could fix it and post it back for you to utilize.