Path Syntax

A

Alex Anderson

Hello Everyone

Could someone tell me what would be the syntax to a combo box located in
the following format. frmmain, tab, subfrm, combo box. In my SQL
statement, I need to locate that combo box but I don't know the syntax. I
have tried to use the following but no luck. Like
[forms]![sfrmSettings].[form]![combo26]

Also, what is this path called within Access so I can read up on it?

Thank you
Alex Anderson
 
K

Ken Snell [MVP]

Forms!frmmain!subfrm!combobox

This assumes that subfrm is the name of the subform control (the control
that holds the subform) on the main form.
 
A

Alex Anderson

Ken,

The below syntax you gave me did not work. However, I was messing
around with expression builder and got the correct syntax. The following is
what I'm using.
Like [Forms]![frmMain]![frmSettings].[Form]![Combo26]

Thank you
Alex Anderson

Ken Snell said:
Forms!frmmain!subfrm!combobox

This assumes that subfrm is the name of the subform control (the control
that holds the subform) on the main form.

--

Ken Snell
<MS ACCESS MVP>

Alex Anderson said:
Hello Everyone

Could someone tell me what would be the syntax to a combo box
Click to expand...
located
in
the following format. frmmain, tab, subfrm, combo box. In my SQL
statement, I need to locate that combo box but I don't know the syntax. I
have tried to use the following but no luck. Like
[forms]![sfrmSettings].[form]![combo26]

Also, what is this path called within Access so I can read up on it?

Thank you
Alex Anderson
Click to expand...
Click to expand...
 
K

Ken Snell [MVP]

Either version will work.

--

Ken Snell
<MS ACCESS MVP>

Alex Anderson said:
Ken,

The below syntax you gave me did not work. However, I was messing
around with expression builder and got the correct syntax. The following is
what I'm using.
Like [Forms]![frmMain]![frmSettings].[Form]![Combo26]

Thank you
Alex Anderson

Ken Snell said:
Forms!frmmain!subfrm!combobox

This assumes that subfrm is the name of the subform control (the control
that holds the subform) on the main form.

--

Ken Snell
<MS ACCESS MVP>

located
Click to expand...
syntax.
I
have tried to use the following but no luck. Like
[forms]![sfrmSettings].[form]![combo26]

Also, what is this path called within Access so I can read up on it?

Thank you
Alex Anderson
Click to expand...
Click to expand...
Click to expand...
 
Top