populate a form from a closed table [Access 2007]

WinDancer

Registered User.
Local time
Yesterday, 20:15
Joined
Oct 29, 2004
Messages
290
Using Access 2007

I am trying to load fields from a closed table- first field is below

Forms!frmtabsurvey!Dba = tables!track2!Doing_business_as_name

I get an 'object required' error message

TIA,
Dave
 
You can't do it like that. You need to either

1. Use a DLookup to get the value

or

2. Use a recordset object to get the value

or

3. include the field in the form's recordsource and bind the control to it.
 

Users who are viewing this thread

Back
Top Bottom