>[frm Research Database Subform.Form]![SYSTEM]
Assuming [frm Research Database Subform] is the name of the *control*
containing your subform, it should be:
[frm Research Database Subform].Form![SYSTEM]
The following has a lot of syntax examples:
http://www.mvps.org/access/forms/frm0031.htm
"Forms: Refer to Form and Subform properties and controls"
1) "Form" is a property of the control, not part of the control name. Odds
are that this is the cause of the "illegal bracketing" error.
2) You may already know this but it's impossible to say from your post:
You can only reference a subform via the Form property of the control
containing the subform. You can *never* use the name of the subform itself
to establish a reference. Exception: when the subform name happens to be
exactly the same as the name of the container control.
A wizard will give the control the same name as the form if you let it, but
that only confuses things IMHO. I always rename my controls, making the
subform name entirely useless and eliminating any confusion. (and I often
change the subform that a control is displaying depending on what the user
is doing, so whatever name the wizard gave the control would quickly become
inappropriate).
HTH,
-----
George Nicholson
Remove 'Junk' from return address.
"DV" <(E-Mail Removed)> wrote in message
news:E4C42F2E-5CE7-4376-8DB7-(E-Mail Removed)...
> Al, this is specifically what I entered:
>
> [Forms]![frm Research Database Users]![frm Research Database
> Subform.Form]![SYSTEM]
>
> and got the following error - Invalid bracketing of name '[Forms]![frm
> Research Database Users]![frm Research Database Subform.Form]![SYSTEM]'
>
> "Al Camp" wrote:
>
>> DV,
>> To reference a value on a subform...
>> Forms!frmMainForm!frmSubForm.Form!FieldName
>> --
>> hth
>> Al Camp
>> Candia Computer Consulting - Candia NH
>> http://home.comcast.net/~cccsolutions
>>
>> "DV" <(E-Mail Removed)> wrote in message
>> news:FF9FC617-A480-4346-9260-(E-Mail Removed)...
>> > I'm having a problem basing a combo box on another. The issue is due
>> > to
>> > the
>> > fact that the combo boxes are both on a sub form, so the query I've
>> > entered
>> > in the row source of ComboBox2 does not work. Does anyone know the
>> > syntax
>> > for the query criteria? This is what I have currently:
>> >
>> > [Forms]![SubForm1]![LimitField1]
>> >
>> > The query looks like this:
>> >
>> > SELECT [Table1].[ReturnField1], [Table1].LimitField1 FROM [Table1]
>> > WHERE
>> > ((([Table1].LimitField1)=[Forms]![Subform1]![LimitField1]));
>>
>>
>>
Similar Threads
