Customised Dropdown ComboBox

[simonmarkjones]

Hi all,

I have 2 ComboBoxes

The first has 3 choices

Planning
Building Control
Planning & Building Control

The second combobox should display criteria from a table based upon
what the user selects from the first box.
In the table there are Department, CodeDescription, Code.

I can get the second combobox to display all the values in this table
called costcode. But i want it only to display the relevant items.

I have sort of got this working by using
SELECT [costcode].[code], [costcode].[CodeDescription],
[costcode].[Department] FROM costcode WHERE
((([costcode].[Department])=[Forms]![CreateNewRecordForm]![PaidTo_combobox]))
ORDER BY [costcode].[Department], [costcode].[CodeDescription];

Paid_To_Combobox being my first combobox.

What happens when i do this is that it works for planning or building
control but when it is both i want to display both however the table
only has codes for planning and codes for building control. And also if
i change the first box i want the second box to catch up with the
changes.

Can anyone help.
Please let me know if you require any more info.

[Salad]

si************@gmail.com wrote:

Hi all,

I have 2 ComboBoxes

The first has 3 choices

Planning
Building Control
Planning & Building Control

The second combobox should display criteria from a table based upon
what the user selects from the first box.
In the table there are Department, CodeDescription, Code.

I can get the second combobox to display all the values in this table
called costcode. But i want it only to display the relevant items.

I have sort of got this working by using
SELECT [costcode].[code], [costcode].[CodeDescription],
[costcode].[Department] FROM costcode WHERE
((([costcode].[Department])=[Forms]![CreateNewRecordForm]![PaidTo_combobox]))
ORDER BY [costcode].[Department], [costcode].[CodeDescription];

Paid_To_Combobox being my first combobox.

What happens when i do this is that it works for planning or building
control but when it is both i want to display both however the table
only has codes for planning and codes for building control. And also if
i change the first box i want the second box to catch up with the
changes.

Can anyone help.
Please let me know if you require any more info.

In your combo rowsource (query), add a column
Expr1:[Forms]![CreateNewRecordForm]![PaidTo_combobox] = "Planning &
Building Control"

In the second row of criteria, enter
True

This creates an Or condition. It will either match the combobox
selection or it's for all conditions.

[simonmarkjones]

Hi i tried that and noting worked.
Basically i want to be able to say

If PaidTo_combobox=Planning then
CostCode1_combobox only shows planning choices
else if PaidTo_combobox=Building Control then
CostCode1_combobox only shows Building Control choices
else (if its Planning & Building Control)
Show both choices

Can i do something like this in my query.
Please help

[Salad]

si************@gmail.com wrote:

Hi i tried that and noting worked.
Basically i want to be able to say

If PaidTo_combobox=Planning then
CostCode1_combobox only shows planning choices
else if PaidTo_combobox=Building Control then
CostCode1_combobox only shows Building Control choices
else (if its Planning & Building Control)
Show both choices

Can i do something like this in my query.
Please help

Did you requery the combo after the selection of Planning or Building oi
Both is selected? Ex:
Me.CostCode1.Requery

If it still doesn't work, debug. Copy the SQL from the comboPaidTo into
a query (Query/New/Design/Close/ViewSQL then Paste. Now open up the
form and select something. Click Window and select the database window
and open up your query and run. You should be able to determine why you
error out.

BTW, is your list a value list...ex Planning, or is it a 2 column combo
like 1;Planning? If so, you need to change the Expr1 to equal the value
, not the text.

[Salad]

si************@gmail.com wrote:

Hi i tried that and noting worked.
Basically i want to be able to say

If PaidTo_combobox=Planning then
CostCode1_combobox only shows planning choices
else if PaidTo_combobox=Building Control then
CostCode1_combobox only shows Building Control choices
else (if its Planning & Building Control)
Show both choices

Can i do something like this in my query.
Please help

Did you requery the combo after the selection of Planning or Building oi
Both is selected? Ex:
Me.CostCode1.Requery

If it still doesn't work, debug. Copy the SQL from the comboPaidTo into
a query (Query/New/Design/Close/ViewSQL then Paste. Now open up the
form and select something. Click Window and select the database window
and open up your query and run. You should be able to determine why you
error out.

BTW, is your list a value list...ex Planning, or is it a 2 column combo
like 1;Planning? If so, you need to change the Expr1 to equal the value
, not the text.