Combo box help

[Tim Graichen]

Hi all,

I think this is pretty basic,

I have a simple subform that has Txtbox1 which displays the field Name from
TblOne. In the same subform, I also have a ComboBox1 which displays field
FirstName from TblNames.

I would like TxtBox1 to by default, continue to read in and display the
value Name from TblOne, but be able to change the value in TxtBox1 via
ComboBox1 when necessary and have the new value saved bact to TblOne.

Thanks a lot!

Tim

[Salad]

Tim Graichen wrote:

Hi all,

I think this is pretty basic,

I have a simple subform that has Txtbox1 which displays the field Name from
TblOne. In the same subform, I also have a ComboBox1 which displays field
FirstName from TblNames.

I would like TxtBox1 to by default, continue to read in and display the
value Name from TblOne, but be able to change the value in TxtBox1 via
ComboBox1 when necessary and have the new value saved bact to TblOne.

Thanks a lot!

Tim

In the AfterUpdate event of the combo enter something like
Me.txtbox1 = Me.combobox1.column(1)
where the second column is the name...since combos start at column
zero...and the first column may be a primary key to tblnames. IOW,
select the column -1 to get the name field inserted.