Quickie / Form Subform

  • Thread starter Thread starter Kevin Sullivan
  • Start date Start date
K

Kevin Sullivan

I have a form, f1.
I have a subform, s1.
There is a field on s1 titled [ID].

I want to use that [ID] field as criteria in a query.

Microsoft shows:

Forms![main form name]![subform control name].Form![control name]

I can't seem to get anything like this to work. What am I doing wrong? TIA!

ks
 
Thank you for the reply!

It ended up that Access named my subform (q1) after the query when I
dragged the subform onto the mainform.

Consequently, when I created my reference, my subform name (s1) and
what access named my subform (q1) on the main form did not match.
Refering to s1 kept erroring out. I simply opened the main form,
renamed the embedded subform (q1) to s1 and it works. :^)

Jim/Chris said:
Try
Forms![f1]![s1].Form![ID]

Jim
-----Original Message-----
I have a form, f1.
I have a subform, s1.
There is a field on s1 titled [ID].

I want to use that [ID] field as criteria in a query.

Microsoft shows:

Forms![main form name]![subform control name].Form![control name]

I can't seem to get anything like this to work. What am I doing wrong? TIA!

ks
.
Click to expand...
Click to expand...
 
Back
Top