Need Help

[Guest]

I created a database with severla tables, querries and forms. On one form
called calibration, I have fields that gets information for other tables. On
this form I type in a gage number and all appropriate information needed is
pull and entered automatically. I want to have a tab created on the form
labled Standard Used and be able to enter in a field another gage number and
have appriopriate information entered into other fields like Description,
calibration date, etc. I am trying to use the DLookUp function
(=DLookup("[Description]", "TBL-Master Gage Log", "[Gage Number] =" _ &
Forms![Calibration]![Gage Number])) with no luck. Can anyone help me with
this. Am I doing something wrong?

 

[Guest]

Take the bracket off the front and back. If Gage Number in your table is
numeric then this is fine
=DLookup("[Description]", "TBL-Master Gage Log", "[Gage Number] =" &
Forms![Calibration]![Gage Number])
If Gage Number in your table is a text field then you will need single
apostrophes around it like this
=DLookup("[Description]", "TBL-Master Gage Log", "[Gage Number] = '" &
Forms![Calibration]![Gage Number] & "'")