First try at creating at option group - please help

[Guest]

Hello All.
I have not attempted to use an option group before, so please bare with me.
I have an archive table, which contains 5 different types of archives, which
I want to call up by using an option group on a form. I have created the
option group and am trying to set the conditions for each in the macro. My
syntax looks like this:
Condition : [accounts filter]=1
Action : ApplyFilter
Archive name : Accounts
Where condition : [Archives]![Box Name] Like "[Acc*]

The error message says MS Access cannot parse the expression [Archives]![Box
Name] Like "[Acc*]. Archives is the table name and Box Name is the column in
the table which holds the 5 types of boxes which I want to be able to filter
using the option group on the form.

Can anyone tell me what is wrong please?
Thanks in advance.

 

[Douglas J Steele]

You're missing a closing quote, and, unless your values look like
[AccountName], [AccountNumber] rather tha AccountName, AccountNumber, you
don't need the square brackets.

Try

[Archives]![Box Name] Like "Acc*"

 

[Guest]

Hello

I have renamed the option group to Archive Filters and subsequently changed
the condition column to read:
[Archive Filters]=1
[Archive Filters]=2 etc.
I have changed th Where Condition criteria to this:
[Forms]![Archives]![Box Name] Like "Acc*"

My error reads:
MS Access cant find the name "archive filters" you entered in the expression

Any ideas?

Thanks.

 

[Guest]

I have tried the following:

[Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Accounts] Like "Acc *"

[Archives]![Accounts] Like "Acc *"

According to MS Access help file, syntax should be:
Forms!formname!controlname
So I changed the syntax to the last 2 samples as above.
Form name is "Archives" and control name is "accounts" in the accounts
filters option group (named Archive Filters) using a toggle button.

I still get the error saying MS Access cannot find the name "Archive
Filters" used in the expression... Is there anything else you could suggest?

Thanks again.

You're missing a closing quote, and, unless your values look like
[AccountName], [AccountNumber] rather tha AccountName, AccountNumber, you
don't need the square brackets.

Try

[Archives]![Box Name] Like "Acc*"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello All.
I have not attempted to use an option group before, so please bare with me.
I have an archive table, which contains 5 different types of archives, which
I want to call up by using an option group on a form. I have created the
option group and am trying to set the conditions for each in the macro. My
syntax looks like this:
Condition : [accounts filter]=1
Action : ApplyFilter
Archive name : Accounts
Where condition : [Archives]![Box Name] Like "[Acc*]

The error message says MS Access cannot parse the expression [Archives]![Box
Name] Like "[Acc*]. Archives is the table name and Box Name is the column in
the table which holds the 5 types of boxes which I want to be able to filter
using the option group on the form.

Can anyone tell me what is wrong please?
Thanks in advance.

 

[Guest]

Error message indicates a syntax error as opposed to a reference error. Check
your operand "Acc*" as opposed to "Acc *" perhaps?
--
Jim

I have tried the following:

[Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Accounts] Like "Acc *"

[Archives]![Accounts] Like "Acc *"

According to MS Access help file, syntax should be:
Forms!formname!controlname
So I changed the syntax to the last 2 samples as above.
Form name is "Archives" and control name is "accounts" in the accounts
filters option group (named Archive Filters) using a toggle button.

I still get the error saying MS Access cannot find the name "Archive
Filters" used in the expression... Is there anything else you could suggest?

Thanks again.

You're missing a closing quote, and, unless your values look like
[AccountName], [AccountNumber] rather tha AccountName, AccountNumber, you
don't need the square brackets.

Try

[Archives]![Box Name] Like "Acc*"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello All.
I have not attempted to use an option group before, so please bare with me.
I have an archive table, which contains 5 different types of archives, which
I want to call up by using an option group on a form. I have created the
option group and am trying to set the conditions for each in the macro. My
syntax looks like this:
Condition : [accounts filter]=1
Action : ApplyFilter
Archive name : Accounts
Where condition : [Archives]![Box Name] Like "[Acc*]

The error message says MS Access cannot parse the expression [Archives]![Box
Name] Like "[Acc*]. Archives is the table name and Box Name is the column in
the table which holds the 5 types of boxes which I want to be able to filter
using the option group on the form.

Can anyone tell me what is wrong please?
Thanks in advance.

 

[Guest]

Jim

Thanks for suggestion, but that's not it. Does the column name need to be
shown somewhere? I see the help file only talks about referencing the from
name and the control name.....

Error message indicates a syntax error as opposed to a reference error. Check
your operand "Acc*" as opposed to "Acc *" perhaps?
--
Jim

I have tried the following:

[Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Box Name] Like "Acc *"

[Forms]![Archives]![Accounts] Like "Acc *"

[Archives]![Accounts] Like "Acc *"

According to MS Access help file, syntax should be:
Forms!formname!controlname
So I changed the syntax to the last 2 samples as above.
Form name is "Archives" and control name is "accounts" in the accounts
filters option group (named Archive Filters) using a toggle button.

I still get the error saying MS Access cannot find the name "Archive
Filters" used in the expression... Is there anything else you could suggest?

Thanks again.

You're missing a closing quote, and, unless your values look like
[AccountName], [AccountNumber] rather tha AccountName, AccountNumber, you
don't need the square brackets.

Try

[Archives]![Box Name] Like "Acc*"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hello All.
I have not attempted to use an option group before, so please bare with
me.
I have an archive table, which contains 5 different types of archives,
which
I want to call up by using an option group on a form. I have created the
option group and am trying to set the conditions for each in the macro. My
syntax looks like this:
Condition : [accounts filter]=1
Action : ApplyFilter
Archive name : Accounts
Where condition : [Archives]![Box Name] Like "[Acc*]

The error message says MS Access cannot parse the expression
[Archives]![Box
Name] Like "[Acc*]. Archives is the table name and Box Name is the column
in
the table which holds the 5 types of boxes which I want to be able to
filter
using the option group on the form.

Can anyone tell me what is wrong please?
Thanks in advance.