Syntax help please?

[WinDancer]

I am trying to fill a numeric field on an open form from an unrelated numeric field in a closed unrelated table.

I keep getting an 'Object Required' error.

Can you see the problem with this code?

Forms![frmOKtoClose?].Text92 = Tables!tblSurveyResultsCount! [CountofChange?]

Thanks,
Dave

 

[pbaldy]

You can't refer to a table that way. You'll either need to open a recordset on the table or use DLookup to get the value.

 

[WinDancer]

Cool- thanks! I will go look at the dlookup function again.

 

[pbaldy]

Good reference here on the syntax:

http://www.mvps.org/access/general/gen0018.htm

 

[WinDancer]

Here is the code that works correctly:
=DLookUp("[Countofchange?]","[tblSurveyResultsCount]")

Thanks, again, guys