Enter Data in Field or Have it Auto Populate from a Combo

[Huddle]

I have a form that I am using for a parameter entry. The user is to enter the building number in a combo box field which is connected as the parameter in the query. I want to add a feature, maybe a combo box, that if they don't know the building number they can look it up by the address. When they select an address I want the building number associated with it to populate the first field. What would you suggest as being the most efficient way to do this?

[June7]

The address search combobox would be unbound. Then in the AfterUpdate event set the value of the other combobox (I use only VBA):

Me.cbxBuilding = Me.cbxAddress

[Huddle]

The BldgCmb would not match the AddCmb. It will pull the building number from the query. Here is the code I have but it is not filling in the BldgCmb.

Private Sub Cmb_Commander_AfterUpdate()
Me.Visible = False
End Sub

Private Sub AddCmb_AfterUpdate()
Me.BldgCmb = Me.AddCmb.Column(3)
RunCommand acCmdSaveRecord
End Sub

Private Sub CityCmb_AfterUpdate()
Me.AddCmb = ""
Me.AddCmb.Requery
RunCommand acCmdSaveRecord
End Sub

Private Sub StateCmb_AfterUpdate()
Me.CityCmb = ""
Me.AddCmb = ""
Me.CityCmb.Requery
RunCommand acCmdSaveRecord
End Sub

[June7]

If you want to provide db, will analyse. Follow instructions at bottom of my post.

Do you want empty strings in fields? If not, set the bound controls to Null, not "". I don't allow empty strings in any fields.

[Huddle]

unfortunately due to highten security at our company I am unable to send the database. I've put an example below if that helps

The building number is CO006.
The address 123 Main.
When the AddCmb field is updated with 123 Main, CO006 should populate the BldgCmb. But I want them to have the option also if they already know the building number to just be able to put it in without going through the addresses.

[June7]

That doesn't help me analyse your issue. I set values of fields with code all the time so can't replicate problem. If you can't scrub the db to remove confidential data and provide it (or an extract of the relevent objects), can't help.

I will add that I don't see need for the acCmdSaveRecord action.

[Huddle]

I figured it out. My column count in the format was off.