G
graffbp
Hey all,
I have a form that has several combo boxes that should display data off of
the entry in the first combo box. The first combo box is Service. The combo
boxes that should filter off of this combo box are Rank, Unit and MOS.
I used a SQL Query to produce the filter, e.g.
SELECT tbl_Rank_Table.RankID, tbl_Rank_Table.Rank, tbl_Rank_Table.ServiceID
FROM tbl_Rank_Table, tbl_Personal_Information WHERE
(((tbl_Rank_Table.ServiceID)=Forms!frm_Personal_Info!Service));=
I then have the following in the AFTER UPDATE section of cbo_Service
Me.Rank = Null
Me.Rank.Requery
Me.Rank = Me.Rank.ItemData(0)
If I add the same code for Unit then when I select a Service, Access prompts
me to input the service again in a pop-up.
Where or how do I need to put the coding for subsequent combo boxes to make
them all update and requery??
Any suggestions would be great.
I have a form that has several combo boxes that should display data off of
the entry in the first combo box. The first combo box is Service. The combo
boxes that should filter off of this combo box are Rank, Unit and MOS.
I used a SQL Query to produce the filter, e.g.
SELECT tbl_Rank_Table.RankID, tbl_Rank_Table.Rank, tbl_Rank_Table.ServiceID
FROM tbl_Rank_Table, tbl_Personal_Information WHERE
(((tbl_Rank_Table.ServiceID)=Forms!frm_Personal_Info!Service));=
I then have the following in the AFTER UPDATE section of cbo_Service
Me.Rank = Null
Me.Rank.Requery
Me.Rank = Me.Rank.ItemData(0)
If I add the same code for Unit then when I select a Service, Access prompts
me to input the service again in a pop-up.
Where or how do I need to put the coding for subsequent combo boxes to make
them all update and requery??
Any suggestions would be great.