A
Allison
I want to use DLookup on a form:
I have a FORM called
Copy of qry:CANTEST:Form and a box
Called NEW CAN#
I also have a table called tbl:CANFY2003
and 5 fields in that table.
I have 5379 records on my form and
I would like to use DLookup and a VB Code
to look at my box labled NEW CAN# on my form
and the table tbl:CANFY2003 and look for the CAN# and four
other fields Research, Division, Pool and Notes that go
along with that CAN and auto field fiels from table on
form. Also so said to use a OnExit() event handler.
Explain where to put the DLook on the form and how to use
the VB code OnExit().
I have a FORM called
Copy of qry:CANTEST:Form and a box
Called NEW CAN#
I also have a table called tbl:CANFY2003
and 5 fields in that table.
I have 5379 records on my form and
I would like to use DLookup and a VB Code
to look at my box labled NEW CAN# on my form
and the table tbl:CANFY2003 and look for the CAN# and four
other fields Research, Division, Pool and Notes that go
along with that CAN and auto field fiels from table on
form. Also so said to use a OnExit() event handler.
Explain where to put the DLook on the form and how to use
the VB code OnExit().