Path Syntax

  • Thread starter Thread starter Alex Anderson
  • Start date Start date
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
 
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,

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...
 
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...
 
Back
Top