Fill in 2nd Textbox2 from Textbox1

[PrimoSteve]

Hello All,

I have an unbound form called Recs with 2 unbound textboxes

Textbox1 called ProductNo
Textbox2 called ProductCode

Textbox1 has the ProductID from the Products Table already filled in
I am trying to fill in Textbox2 with the ProductCode corresponding to the ProductID from the Products Table

Thanks in advance!

 

[dhookom]

I would change the ProductID control to a combo box that has the ProductCode in its Row Source. You can the display the ProductCode using a control source of:

=[your combo box name].Column(x)

X is the column number beginning with 0 as the first column.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

Or, instead of Textbox1 for ProductNo/ProductID, keep this data in a variable:
(if numeric, then)
[tt]Dim lngProductID As Long[/tt]
and use DLookup Function to get the value for the ProductCode

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[PrimoSteve]

Hi Duane / Andy,

It's been awhile but I did use the the DLookup Function and it's working perfect!

Many thanks for the suggestion much appreciated,

Steve