Referencing a field in a table from a form

Mechele

Registered User.
Local time
Today, 01:35
Joined
Jan 25, 2002
Messages
121
What is wrong with the following statement?

Tables!Clinical!Memid = Me!Memid

I am getting an "object required" error message
 
I don't think you can just refer to a table field the same way you would refer to a form field. For one thing, since tables typically have multiple records, there needs to be some way to specify which record's value you want for the specified field.

You could use DAO recordsets (or ADO if you have Access 2000 or later) to directly manipulate the table, find the record you want and edit it, all in VBA code.
 

Users who are viewing this thread

Back
Top Bottom