Unbound Combo Box

[Guest]

I have an Order Form and on that form I have an unbounded combo box. When I
am selecting customer last and a first name fields (address, zip, city) are
populated using code: =Combo_From.Column(3) etc. This is ok however when
costumer is placing an order from different location, then the one define in
customer table, I am unable to delete address and put new address. Is there
any way I can delete that location and enter new location? Thanks

 

[Guest]

Instead of use the ControlSource property to display the combobox data, push
the data to the unbound textboxes in the AfterUpdate event of the combo.
Aircode:

Sub MyCombo_AfterUpdate()
Me.txtShipToAddress = Me.MyCombo.Column(3)
Me.txtShipToCity = Me.MyCombo.Column(3)
' yada yada
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thank a lot.

Instead of use the ControlSource property to display the combobox data, push
the data to the unbound textboxes in the AfterUpdate event of the combo.
Aircode:

Sub MyCombo_AfterUpdate()
Me.txtShipToAddress = Me.MyCombo.Column(3)
Me.txtShipToCity = Me.MyCombo.Column(3)
' yada yada
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access