Synchronizing Combo boxes

[G]

Hi there, How do I go about synchronizing 3 combo boxes??
I can get the first two to work, but the third combo box
does not function at all.

thanks in advance

G

 

[Van T. Dinh]

Try The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm

 

[G]

Thanks for the info Van, but I have one more question regarding this issue, from the example you have giving me the RowSourceType is set to a field value, however on my db I have it set up as a Query/Table, how do I solve this problem if I want to use Query/Table instead of Field value???

Once again thank you for the info!



----- Van T. Dinh wrote: ----

Try The Access Web article

http://www.mvps.org/access/forms/frm0028.ht

 

[Van T. Dinh]

The RowSourceType of the first ComboBox is not important. The important
part is the Query/SQL String for the second ComboBox.

Read the whole article and try the second ComboBox.

--
HTH
Van T. Dinh
MVP (Access)

Thanks for the info Van, but I have one more question regarding this

issue, from the example you have giving me the RowSourceType is set to a
field value, however on my db I have it set up as a Query/Table, how do I
solve this problem if I want to use Query/Table instead of Field value????

 

[G.]

Hi: It's me yet once again. I have read the article like you have suggested, made the modifications but still it doesn't work. My query is pretty much like the one in the article, I also
included in the AfterUpdate sub Me!combo2.Requery.

i have Row Source Type = Table/Query, RowSource = tbl_one.
2nd box Row Source Type = Table/Query, RowSource = qry_combox
3rd box Row Source Type = Table/Query, RowSource = qry_combox2

qry_combox is as follow:
SELECT DISTINCTROW [tbl_two].[field], [tbl_two].[field2]
FROM [tbl_two]
WHERE ((([tbl_two].[field3])=[Forms]![frmName]![combox1]))
ORDER BY [tbl_two].[field2];

Once again thanks for all your help but do u have any idea what I am doing wrong???

G.

 

[Van T. Dinh]

Which ComboBox doesn't work? What do you mean by don't work? No rows
returned? Rows returned but the rows don't change accroding to previous
ComboBox selection?

Check and make sure that you use the correct corresponding Fields in each
Parameter in the Query.

--
HTH
Van T. Dinh
MVP (Access)

Hi: It's me yet once again. I have read the article like you have

suggested, made the modifications but still it doesn't work. My query is
pretty much like the one in the article, I also

included in the AfterUpdate sub Me!combo2.Requery.

i have Row Source Type = Table/Query, RowSource = tbl_one.
2nd box Row Source Type = Table/Query, RowSource = qry_combox
3rd box Row Source Type = Table/Query, RowSource = qry_combox2

qry_combox is as follow:
SELECT DISTINCTROW [tbl_two].[field], [tbl_two].[field2]
FROM [tbl_two]
WHERE ((([tbl_two].[field3])=[Forms]![frmName]![combox1]))
ORDER BY [tbl_two].[field2];

Once again thanks for all your help but do u have any idea what I am doing wrong???

G.