Form Combo Box-Like Cascading

[awach]

I search thru cascading combo boxes and other similar questions and can't
find anything yet. Some help please:

I have three combo boxes on a form: Type, Held, Model

I want the second's options to based on the selection from the first and the
third's options to be based on the selection from the second.

I am basically trying to say

If [Type]="K", then Held's options should be pulled from
Homepage.Company(different table than where Type is)

AND for the second combo

If [Held]="External", then Model's options should be pulled from Models.Name
(different table than where Held is)

Any help would be appreciated. Thanks.

 

[KARL DEWEY]

The source for the second based on query using first as criteria. The source
for the third based on query using second as criteria. Refresh after
selecting.

 

[awach]

Could you give me a little more specific direction...I'm still somewhat new
with Access? Thanks.

The source for the second based on query using first as criteria. The source
for the third based on query using second as criteria. Refresh after
selecting.
--
KARL DEWEY
Build a little - Test a little

I search thru cascading combo boxes and other similar questions and can't
find anything yet. Some help please:

I have three combo boxes on a form: Type, Held, Model

I want the second's options to based on the selection from the first and the
third's options to be based on the selection from the second.

I am basically trying to say

If [Type]="K", then Held's options should be pulled from
Homepage.Company(different table than where Type is)

AND for the second combo

If [Held]="External", then Model's options should be pulled from Models.Name
(different table than where Held is)

Any help would be appreciated. Thanks.

 

[KARL DEWEY]

Build a query using the first combo as criteria to pull list for use by the
second combo.
Copy the SQL of the query, open the form in design view, click on the second
combo, right click the combo, select Properties (last item on the list),
paste as source.
Create an event for the first combo on update to refresh.
--
KARL DEWEY
Build a little - Test a little

Could you give me a little more specific direction...I'm still somewhat new
with Access? Thanks.

The source for the second based on query using first as criteria. The source
for the third based on query using second as criteria. Refresh after
selecting.
--
KARL DEWEY
Build a little - Test a little

I search thru cascading combo boxes and other similar questions and can't
find anything yet. Some help please:

I have three combo boxes on a form: Type, Held, Model

I want the second's options to based on the selection from the first and the
third's options to be based on the selection from the second.

I am basically trying to say

If [Type]="K", then Held's options should be pulled from
Homepage.Company(different table than where Type is)

AND for the second combo

If [Held]="External", then Model's options should be pulled from Models.Name
(different table than where Held is)

Any help would be appreciated. Thanks.

 

[awach]

I don't think that I can make a query like that because the two tables (the
one for Type and the one for Held) are unrelated. How can I make a query
connecting them?

Build a query using the first combo as criteria to pull list for use by the
second combo.
Copy the SQL of the query, open the form in design view, click on the second
combo, right click the combo, select Properties (last item on the list),
paste as source.
Create an event for the first combo on update to refresh.
--
KARL DEWEY
Build a little - Test a little

Could you give me a little more specific direction...I'm still somewhat new
with Access? Thanks.

The source for the second based on query using first as criteria. The source
for the third based on query using second as criteria. Refresh after
selecting.
--
KARL DEWEY
Build a little - Test a little


:

I search thru cascading combo boxes and other similar questions and can't
find anything yet. Some help please:

I have three combo boxes on a form: Type, Held, Model

I want the second's options to based on the selection from the first and the
third's options to be based on the selection from the second.

I am basically trying to say

If [Type]="K", then Held's options should be pulled from
Homepage.Company(different table than where Type is)

AND for the second combo

If [Held]="External", then Model's options should be pulled from Models.Name
(different table than where Held is)

Any help would be appreciated. Thanks.

 

[KARL DEWEY]

If what you will select using the first combo has no relation to that for the
second combo then it will never work.

Post the tables listing the field names and a sample of data.

--
KARL DEWEY
Build a little - Test a little

I don't think that I can make a query like that because the two tables (the
one for Type and the one for Held) are unrelated. How can I make a query
connecting them?

Build a query using the first combo as criteria to pull list for use by the
second combo.
Copy the SQL of the query, open the form in design view, click on the second
combo, right click the combo, select Properties (last item on the list),
paste as source.
Create an event for the first combo on update to refresh.
--
KARL DEWEY
Build a little - Test a little

Could you give me a little more specific direction...I'm still somewhat new
with Access? Thanks.

:

The source for the second based on query using first as criteria. The source
for the third based on query using second as criteria. Refresh after
selecting.
--
KARL DEWEY
Build a little - Test a little


:

I search thru cascading combo boxes and other similar questions and can't
find anything yet. Some help please:

I have three combo boxes on a form: Type, Held, Model

I want the second's options to based on the selection from the first and the
third's options to be based on the selection from the second.

I am basically trying to say

If [Type]="K", then Held's options should be pulled from
Homepage.Company(different table than where Type is)

AND for the second combo

If [Held]="External", then Model's options should be pulled from Models.Name
(different table than where Held is)

Any help would be appreciated. Thanks.