Pulling in ID from another field in a different form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

I'm trying to pull over an ID from a primary table into a foreign field.
I've put this syntax into the criteria of the query, but it's not pulling
from the primary table form...the syntax is correct...what else could be the
problem?
Foreign field = APDS_ID (in AppraisalEventChange table)
(from)
[Forms]![frmAppraisalFILENEW]![APDS_ID] (Appraisal table)
Thanks,
petra
 
Petra

The syntax you provided implies that there's a field named "APDS_ID" on the
form to which you refer -- can you confirm this? You have not provided the
SQL statement of the query you are using to try this.
 
Back
Top