Combo Box to Populate Text box and save Values in Table

[color=Purple]Hello,

Please help!!!

I have a form that a Combo Box (Originator_Broker) and Text Box (Cas Number). The combo box contains the Originator Name and when one is selected it populates the Cas Number in the text box. This works fine on the form but, when a record is saved, in the Table the data in the Combo Box is visible however the Text Box field in the table is blank.

How can I save the Value of the Text Box as well?

Any help is greatly appreciated!!


tblOriginator_Broker has two fields [b]Originator_Name [/b]and [b]Cas_ID[/b]


combobox is [b]Originator_Broker[/b]
textbox [b]Cas_Number[/b]


Here is my code:

[code]Private Sub Originator_Broker_AfterUpdate()
Me!Cas_Number = Me!Originator_Broker.Column(1)

End Sub[/code][/color]

Comments

  • : [color=Purple]Hello,
    :
    : Please help!!!
    :
    : I have a form that a Combo Box (Originator_Broker) and Text Box (Cas
    : Number). The combo box contains the Originator Name and when one is
    : selected it populates the Cas Number in the text box. This works
    : fine on the form but, when a record is saved, in the Table the data
    : in the Combo Box is visible however the Text Box field in the table
    : is blank.
    :
    : How can I save the Value of the Text Box as well?
    :
    : Any help is greatly appreciated!!
    :
    :
    : tblOriginator_Broker has two fields [b]Originator_Name [/b]and
    : [b]Cas_ID[/b]
    :
    :
    : combobox is [b]Originator_Broker[/b]
    : textbox [b]Cas_Number[/b]
    :
    :
    : Here is my code:
    :
    : [code]: Private Sub Originator_Broker_AfterUpdate()
    : Me!Cas_Number = Me!Originator_Broker.Column(1)
    :
    : End Sub[/code]: [/color]
    :

    is the cas number textbox bound to a field? is the textbox control_source set to a field, or blank [that is unbound]. you could use the controls afterupdate or lostfocus event to update the value in the table.
  • Please my userid is Lizzy123.

    I need other programmers userid so that i can be able to communicate and send in my questions and aslo my response.

    Thanks:

    [color=Purple]Hello,
    :
    : Please help!!!
    :
    : I have a form that a Combo Box (Originator_Broker) and Text Box (Cas
    : Number). The combo box contains the Originator Name and when one is
    : selected it populates the Cas Number in the text box. This works
    : fine on the form but, when a record is saved, in the Table the data
    : in the Combo Box is visible however the Text Box field in the table
    : is blank.
    :
    : How can I save the Value of the Text Box as well?
    :
    : Any help is greatly appreciated!!
    :
    :
    : tblOriginator_Broker has two fields [b]Originator_Name [/b]and
    : [b]Cas_ID[/b]
    :
    :
    : combobox is [b]Originator_Broker[/b]
    : textbox [b]Cas_Number[/b]
    :
    :
    : Here is my code:
    :
    : [code]: Private Sub Originator_Broker_AfterUpdate()
    : Me!Cas_Number = Me!Originator_Broker.Column(1)
    :
    : End Sub[/code]: [/color]
    :

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories