Using bound combo box without changing record?

[ittechguy]

I've got a form I'm building. its rather rough but thus far it looks like this:





I have two sets of identical boxes, "Physical location" and "Change Physical Location." One is a set of locked text boxes which displays current location, the other is a set of combo boxes used to change the CabinetPK which the equipment on the form is assigned to. The field I'm updating is tblEquipment.CabinetFK. I'm trying to combine the two sets of boxes so that there is only 3 combo boxes.

The issue I was having with that is that Building Name and Room Name are both bound to their respective number fields in the query. However, they are used to display information and also all three boxes are cascading as to ensure you select the correct Cabinet Name. So, because they are bound to BuildingFK and RoomFK, if I select a new building, room, and cabinet it will not allow me to save the record. It tells me that would create duplicate entries in the table.

Sooo, is there any way to get the Building Name and Room Name combo box to display the correct building/room (so that the user is not confused), but when a new value is selected from the combo box... only Cabinet Name is updated? I'm guessing I have to us VBA code to unbound the cbo boxes and then bind them again after the update has been made?

[Gina Maylone]

Hi!

You could use an unbound text box or boxes with a dlookup function. dlookup("buildingname","yourtablename","yourcriter ia") and do the same for room number, then create another text box and in the control source put "me.textbox1&" "&me.textbox2". Which will combine the values of the two lookup text boxes.

HTH
Gina