how do i specify the value of a continuous form field value

[mdavid]

Hi I need to specify a form field value on a continuous form in a select WHERE clause to populate a listbox, I have:

WHERE (((MempBerkPrepAdmin.ComplaintGrpID)= Forms![MainComplaintsFrm].Form![ComplaintsDetailFrm].form![CompID].value));



Which I built using Expression Builder but it doesn't work (ie. doesn't returun any results).

Any help appreciated.

David

[June7]

Where is the listbox located?

Suggest you name the subform container different from the object it holds, like ctrComplaints.

Then if the listbox is on the main form:

WHERE ComplaintGrpID = ctrComplaints!CompID

[Micron]

First, the syntax doesn't look right if this is a subform on a form and the control you want is on the subfom. Try
[Forms]![Main form name]![subform control name].[Form]![control name on subform]
where subformcontrol name is the name of the control that contains the subform. It is not the subform itself. You seem to have too many of Form! and I suspect you're missing the subform control reference, but you don't identify what's what so I'm guessing.

[mdavid]

Hi, Thanks for reply's.
Sorry didn't give all the story.
The subform container where the listbox is a TabControl Page - TabCtl23.Page24 - and the form in question is a continuous form.

So what I want to get to is:

MainComplaintsFrm (Single Form) > TabCtl23 > Page24 > ComplaintsDetailFrm (continuous form) > CompID.Value

[ArviLaanemets]

Tab's and tab Page's don't affect how you reference to controls. I.e. the syntax doesn't depend from, are you referring to main form control from subform on this main form, or from subform on some page of tab control in main form. And same for referring to subform from main form.

[June7]

As Arvil said, the Tab control is irrelevant.

If listbox is directly on page of tab control, then consider it as just on the main form and suggestion in post 2 should work.

[mdavid]

I tried:

Forms![MainComplaintsFrm].Form![ComplaintsDetailFrm].Form![CompID]

Which doesn't return anything - I dragged the form ComplaintsDetailFrm directly onto the TabControl Page so I don't have a subform container, do I need to first open a subform control and drag the continuous form onto that?

Thanks
David

[ArviLaanemets]

Subform is added automatically whenever you drag a form into another one. To test it:
Activate main form in edit mode (click at left upper corner of main form) and activate form properties. In Properties window, you see properties for main form;
Click ONCE on left upper corner of what you think to be second form - at top of properties is said, that subform is activated. When you look at source property, you see that the second form is the source for subform;
Click again on left upper corner of subform - now you can see properties of your inserted form.

By default the subform container gets same name as the form it contains. To avoid confusion, rename the subform container.

[mdavid]

Hi Arvi,
Thanks for your detailed explanation, much appreciated.
I did as you suggested and created a new control reference, but it still didn't produce any results, so I put a textbox on the form with the control reference as the control source and the value appeared in the textbox, so the reference is ok and I've marked this thread as solved. I will continue looking elsewhere for the problem.

Thank you all for your help
I'm learning alot - my problem is remembering it!

David