Question Populate unbound txtbox with combo box after update event (1 Viewer)

[josephbupe]

Hi,

I am populating a table using combo boxes in a continuous form. The box box alone works fine without any issue of repeated data. But as you know obviously the combo box only populates data in a single column of the table, in which case mine is the LASTNAME; so now I am attempting to populate a unbound textbox with the FIRSTNAME side-by-side with the combo box for the same record.

In the After Update event of the cboLASTNAME:

Me.txtFIRSTNAME = Me.cboLASTNAME.Column(3)

However, after updating the the combo the textbox data is repeated.

Is there a possible solution to this?

Joseph

 

[Dezirous]

Hi Dear,

can you please let me know the rowSource of you combo and columnWidth value?

Suggestion for you Problem: Use dlookup("[Lastname]","tblName","[ID]=" & Me.cboLASTNAME & "")

Like me.txtFirstName = dlookup("[Lastname]","tblName","[ID]=" & Me.cboLASTNAME & "")

 

[John Big Booty]

The problem is that you are using that technique on a continuous or Data-sheet form.

When you have a field that derives it's data from a field in the current record, on either of those types of form, then all instances of that derived control will reflect the data held in the record that currently holds focus.

You can get around this by using a query to populate your form and then using a pop-up form to add records to the underlying tables.