Combo Boxes

[Luddite Lad]

I'm sure this question must have been asked before but I can't find it here, so my apologies.

I have a form for collecting addresses, it has two combo boxes, the first contains a list of states, and then the second contains a list of postcodes found within that state based up a query with the criteria

[forms]![FRM_Delpoint]![StateID]

the problem is the second combo box always shows the list relevant to the first record.

 

[Oldsoftboss]

Is it in a continious form?

 

[Luddite Lad]

No single form view.

 

[obeylele]

do a requery of your postcodes field aftter update of states

it would be like

Private Sub sates_AfterUpdate()
me.postcodes.requery
End Sub

 

[ScottGem]

I'm sure this question must have been asked before but I can't find it here, so my apologies.

I have a form for collecting addresses, it has two combo boxes, the first contains a list of states, and then the second contains a list of postcodes found within that state based up a query with the criteria

[forms]![FRM_Delpoint]![StateID]

the problem is the second combo box always shows the list relevant to the first record.

Have you setup the combos to be synchronized or cascading? Here's an article that describes how:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

 

[Luddite Lad]

Thanks guys that's got it working