getting DLookup to enter data in a form from a linked table (1 Viewer)

[jgaweda]

i recently set up a series of databases. On one form when i enter a contract number, i want access to go to a linked table and when it finds a match fill in contract name and contract description from a linked table, based upon finding a matching contract number. I entered Dlookup on a calculated control on the active form and every time i run it all i get is #error any suggestions?

 

[GMC]

Have you tried creating a recordset to search the linked table. As long as you open the temporary recordset as a Dynaset there shouldn't be any problems. Also, make sure you use the Find methods as Seek doesn't work on Linked Tables.

If you need any extra help then mail me on grantmcarr@hotmail.com

Hope this helps

Grant