check boxes on a parameter form

  • Thread starter Thread starter RES
  • Start date Start date
R

RES

I've created a 1 table (tblContacts), that have Last Name, First Name,
Address, City, State, Zip fields and several yes no check boxes (Business,
Personal, Residential, Multi-Buyer, Investor-Buyer, Commerical), and 1 drop
down list for Hot, Warm, Cold. This db creates labels from queries for each
check box, which is working fine.

I'm trying to create a parameter form, so that I can check the boxes and
generate labels based on the check boxes for Business, Personal, Residential,
Multi-Buyer, Investor-Buyer, Commerical) along with Hot, Warm and Cold. For
example: I want to print all the labels that are Business, specific City or
Zip, that are Residential and Hot. Another example: I want to print labels
that are Personal, specific zip codes, like 13088 and 13090, that are
Multi-Buyer and Commerical that are Hot.

Can anyone help with this problem?
 
The way to make this work is in the queries criteria.

IIf(IsNull([Forms]![ParameterFormName]![Yes/NoParameter]),
[NameOfTheColumnInTheQuery],[Forms]![ParameterFormName]![Yes/NoParameter])

This says if there is nothing in the parameter form to us all, but if there
is a value in the paramter form to use it as the criteria for that column.
This is a more readable example.

IIf(IsNull([Forms]![LabelParameters]![BusinessFilter]),[Business],
[Forms]![LabelParameters]![BusinessFilter])
 
Thanks Ryan,

I'll give it a try and let you know. Will you be checking in periodically
over the weekend?

RES

--
RES


Ryan said:
The way to make this work is in the queries criteria.

IIf(IsNull([Forms]![ParameterFormName]![Yes/NoParameter]),
[NameOfTheColumnInTheQuery],[Forms]![ParameterFormName]![Yes/NoParameter])

This says if there is nothing in the parameter form to us all, but if there
is a value in the paramter form to use it as the criteria for that column.
This is a more readable example.

IIf(IsNull([Forms]![LabelParameters]![BusinessFilter]),[Business],
[Forms]![LabelParameters]![BusinessFilter])
--
Please remember to mark this post as answered if this solves your problem.


RES said:
I've created a 1 table (tblContacts), that have Last Name, First Name,
Address, City, State, Zip fields and several yes no check boxes (Business,
Personal, Residential, Multi-Buyer, Investor-Buyer, Commerical), and 1 drop
down list for Hot, Warm, Cold. This db creates labels from queries for each
check box, which is working fine.

I'm trying to create a parameter form, so that I can check the boxes and
generate labels based on the check boxes for Business, Personal, Residential,
Multi-Buyer, Investor-Buyer, Commerical) along with Hot, Warm and Cold. For
example: I want to print all the labels that are Business, specific City or
Zip, that are Residential and Hot. Another example: I want to print labels
that are Personal, specific zip codes, like 13088 and 13090, that are
Multi-Buyer and Commerical that are Hot.

Can anyone help with this problem?
 
Did you get that to work for you?
--
Please remember to mark this post as answered if this solves your problem.


RES said:
Thanks Ryan,

I'll give it a try and let you know. Will you be checking in periodically
over the weekend?

RES

--
RES


Ryan said:
The way to make this work is in the queries criteria.

IIf(IsNull([Forms]![ParameterFormName]![Yes/NoParameter]),
[NameOfTheColumnInTheQuery],[Forms]![ParameterFormName]![Yes/NoParameter])

This says if there is nothing in the parameter form to us all, but if there
is a value in the paramter form to use it as the criteria for that column.
This is a more readable example.

IIf(IsNull([Forms]![LabelParameters]![BusinessFilter]),[Business],
[Forms]![LabelParameters]![BusinessFilter])
--
Please remember to mark this post as answered if this solves your problem.


RES said:
I've created a 1 table (tblContacts), that have Last Name, First Name,
Address, City, State, Zip fields and several yes no check boxes (Business,
Personal, Residential, Multi-Buyer, Investor-Buyer, Commerical), and 1 drop
down list for Hot, Warm, Cold. This db creates labels from queries for each
check box, which is working fine.

I'm trying to create a parameter form, so that I can check the boxes and
generate labels based on the check boxes for Business, Personal, Residential,
Multi-Buyer, Investor-Buyer, Commerical) along with Hot, Warm and Cold. For
example: I want to print all the labels that are Business, specific City or
Zip, that are Residential and Hot. Another example: I want to print labels
that are Personal, specific zip codes, like 13088 and 13090, that are
Multi-Buyer and Commerical that are Hot.

Can anyone help with this problem?
 
Back
Top