Automaticlly fill a text box from a table

[West48]

How can I fill in a text box on a form automatically when I enter a value in an other combo box on the form? Both these values come from a table that contain two fields [name] and [size]. I want to automaticlly inter [size] when I enter [name] in the combo box.

 

[solo7]

How about usuing the DLOOKUP function on the combo box's AFTERUPDATE event. Build the selection criteria by referencing the target box that holds the search criteria.

So if you have selected data from the combo box Combo1 then use something like

TextBoxAutofillMe.Value = Dlookup("Fld_ToLookup","TblToLookUpIn","Fld_SearchField=" & combo1.value &)

You'll have to play around with the syntax as the above is a very rough approximation of what will work for you.

Solo7

 

[SeeThru]

An alternative is to add a hidden second column to the combo box (set the width to '0') and then refer to is in the AfterUpdate of the combo box.

TextBox=combobox.colums(1).value

Probably be faster, depending on how big the tables are.....