combo box contents depending on previous filed's selection?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im new to Access. I want to create a data entry screen consisting of a number
of fileds with drop down lists (combo box). I need to make the contents of a
field's list dependent on what was chosen from the list in the previous field.
Can this be done?
 
Fenrir,
On my website (below) I have a sample A97 or A2003 file called SybchedCombos. It shows
how to limit the contents of combo2 according to combo1 (or another field). Basically you
just use the 1st value to filter the combo query in the 2nd combo.
 
I do the cbo2 based on a query that is filtered by the value of the cbo1, but
then insert an event with the following code to keep rerunning the query
every time the cbo1 is updated. cbo1 is called cboGoalNo, and cbo2 is called
cboObjNo. This is a training database, and I want the objectives connected
to a goal to be the only ones available for choosing. The subform is called
POTssfrm.

Private Sub cboGoalNo_AfterUpdate()
Me![POTssfrm].Requery
Me![POTssfrm].[Form]![cboObjNo].Requery

End Sub
 
Back
Top