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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Update query syntax: SUM and GROUP BY 3
an ab-normal bite in the rear end ? 6
Pulling data from a linked SQL table 2
subtrscting 2 different columns from 2 tables 3
Append Query problem 2
criteria on form 1
query to overcome field type problem? 4

Back
Top