How to make unbound combobox display value from table

[ittechguy]

I'm creating a popup form which allows me to change customer information.





Its a little rough now, but the one on top displays the values for the record in tblCustomer selected from another form. It uses DLookup to pull the values from separate lookup tables and it uses hidden textboxes which are bound to the FKs (OrganizationFK, ShopNameFK, OfficeSymFK, and RankFK) from tblCustomer.

The form on the bottom is to make changes. So a user would select a value form each combobox and type in a name or whatever else needs to be changed, and hit the change button.

How can I combine these two? I would like to have combo boxes display information, but then also be used to change information.

I suppose I could add the lookup tables to a query for this form, but I think that would make the form un-editable, or at least not easily.

[ittechguy]

Nvm. I feel stupid, I really shouldn't code while tired.

All I had to do was bind each combo box to their respective FKs and have it display the name in the second column.

[ittechguy]

I even figured out how to make it ask the user if they are sure they want to make changes.

Private Sub cmdChange_Click()    MsgBox "Are you sure you want to make changes to this customer?", vbYesNo
    If vbYes Then
            Me.Requery
    Else
            Me.Undo
    End If
End Sub