drop down box

[sadie]

I have a form with some drop down 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

 

[trucktime]

Combo

Perhaps you can post the db (without sensitive data), so we can have a look at it.