Question Forms

[arnelgp]

See the code relink the tables

 

[Russell08]

Arnel,

Thanks you so much!
I think we are nearly there! or rather you are.

The only problem I have now is the Serial number is contained within two textbox's.OWNER and NWQIS.

OWNER is TEXT and NWQIS is NUMERICAL.
Only NWQIS is showing in the new Textbox MeterSerial).
How do I get the first part (OWNER) to show up as well?

Russell

 

[arnelgp]

first delete all data from the meterserial field, so
we can insert the fresh meterserial:

currentdb.execute "update [calibration shee] set meterserial=null"


next open your calibration form on Design view and change
End_User_Name_AfterUpdate() Event.

change this:

meterSerial = DLookup("[NWQIS]", "[CALIBRATION SHEET]", "[END USER NAME]='" & Me![END USER NAME] & "' and [DEPLOYMENT DATE] = #" & Format(dt, "mm/dd/yyyy") & "#")


to:


meterSerial = DLookup("[OWNER] & (' ' + [NWQIS])", "[CALIBRATION SHEET]", "[END USER NAME]='" & Me![END USER NAME] & "' and [DEPLOYMENT DATE] = #" & Format(dt, "mm/dd/yyyy") & "#")

 

[Russell08]

Arnel,
It works perfectly!
Thank so much for your help and patience.
You my friend are a Star!!!