Combo Box Selections

[imbd4a]

I have a situation where I have a unbounded main form with 2 combo boxes
located in the header. Within the detail of the form lives a subform.

Combobox_1 is unbound and generates a list from a table for its dropdown
selection. I would like Combobox_2 to be a select list of only those
elements which satisfy the criteria of combobox_1. Then I would like the
subform to link to the selections of Combobox_2.

How do I do this and keep them all synced?

Thanks

 

[M.L. Sco Scofield]

Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576.

It describes how to synchronize a couple of comboboxes. Start with that.

It should be fairly simple to extend the technique to synchronizing a form.
If you have trouble, post back.

Good luck.

Sco

 

[imbd4a]

Sorry 'bout that...I meant to repost not reply.
That did it, Thanks.
Now that the boxes are working how do I get the subform to refresh itself on
the combobox_2 selection once it is made?
Thanks again.
B

 

[Ken Snell]

On the AfterUpdate event of combobox_2, requery the subform:

Private Sub combobox_2_AfterUpdate()
Me.Subform.Form.Requery
End Sub

Where Subform is the name of the control that holds the subform.

 

[imbd4a]

Thanks Guys !

On the AfterUpdate event of combobox_2, requery the subform:

Private Sub combobox_2_AfterUpdate()
Me.Subform.Form.Requery
End Sub

Where Subform is the name of the control that holds the subform.

--

Ken Snell
<MS ACCESS MVP>

itself

 

[M.L. Sco Scofield]

Thanks for jumping in and finishing the job Ken.

Sco

 

[Ken Snell]

One good turn deserves another! You've done the same for me many times , g