Text Box to Show linked field

[LOKIDOG]

I would like to have my form show a value in a linked table based on the value entered.

Here the scheme.

I enter species codes in 8 fields. My lookup table for each of these fields has the species name in it as well so when you choose the species you know the code and species.

But I would like a text box to show the species name for each of these fields too - so the species name is always visible once it's selected. It's important to error checking. How can I do this? Thanks.

 

[BoxHead]

Look at DLookUp in Help

Something like....

Iif(Nz(txtBox1,"")="","",DLookUp("[speciesName]","mySpeciesTable","[speciesNum] = " & txtBox1)

HTH


John

Use what you have,
Learn what you can,
Create what you need.

 

[PHV]

Why not using a ComboBox for each species code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886