Howdy, Stranger!

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

Categories

Combo Box to Populate Text box and save Values in Table

VMRVMR Member Posts: 2
[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

  • dokken2dokken2 Member Posts: 532
    : [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.
  • Lizzy123Lizzy123 Member Posts: 2
    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.