Popup form for adding customers

[ittechguy]

I'm having an issue with my popup form.

The form shows the room id from my main form and displays the building name and room name.

I need to use the form to make changes to my junction table between customers and rooms (CustomersToRooms). I've created a form based on my CustomersToRooms table.

Now I need to be able to select a customer to add it to the room. I am not sure how to do this.

I can concatenate first name and last name and allow users to select a first name and last name with one combo box. And bind that to customerid. However I do have some common first and last names so it's possible to get duplicates this way.

One method that works but looks weird, is to include all fields from my customer table in my combo box. I was hoping to separate this more.

[CJ_London]

if you have multiple customers with the same names you will need to display more information in the combo box so the user can differentiate them - e.g. a postcode or telephone number or perhaps a start date

Your customer combobox should have the bound columns set to your customerID

[ranman256]

is say use a multi record form, with a text box.
enter the name in the box, filter records
show all like names.
select 1 rec, click DETAIL button to edit the record via
docmd.openform "frmDetail", ,,"[id]=" & txtID