I have a form based on a table called calc. On that form, I have a fields called idnumber and standard.
I would like to do the following... If the valve in idnumber (after update) equals or exists in table main (a different table)
then the valve on my form for standard is the valve from table main.
Basically, I would like to get the valve from another table if it's equal and paste that valve into my form.
I guessing some kind of dlookup? Hope I explained it well enough...
I would like to do the following... If the valve in idnumber (after update) equals or exists in table main (a different table)
then the valve on my form for standard is the valve from table main.
Basically, I would like to get the valve from another table if it's equal and paste that valve into my form.
I guessing some kind of dlookup? Hope I explained it well enough...