automatic fill

hello
on my form i have made an organized layout to comprise of four experiments (a-
d). the resin used for experiment A, is chosen using a cascading combo box
and automatically fillled in under txt field for experiment A resin.

my question is how to make the resin selection cascading box work for all
four different potential materials.(A-D).

as of now this is my code

Private Sub Combo0_AfterUpdate()
Me.Combo2.Requery
Me.Combo2 = Null


Me.Combo6.Requery
Me.Combo6 = Null
End Sub


Private Sub Combo2_AfterUpdate()
Me.Combo6.Requery
Me.Combo6 = Null
End Sub

Private Sub Combo6_AfterUpdate()

Forms![LABLINEEXTRUSION1]![ResinA] = Me.Combo6

End Sub


Thanks

--
Message posted via http://www.accessmonster.com

I would check Allen Browne at www.allenbrowne.com. I think he has some good
stuff on that on his site.

"misschanda via AccessMonster.com" wrote:

hello
on my form i have made an organized layout to comprise of four experiments (a-
d). the resin used for experiment A, is chosen using a cascading combo box
and automatically fillled in under txt field for experiment A resin.

my question is how to make the resin selection cascading box work for all
four different potential materials.(A-D).

as of now this is my code

Private Sub Combo0_AfterUpdate()
Me.Combo2.Requery
Me.Combo2 = Null


Me.Combo6.Requery
Me.Combo6 = Null
End Sub


Private Sub Combo2_AfterUpdate()
Me.Combo6.Requery
Me.Combo6 = Null
End Sub

Private Sub Combo6_AfterUpdate()

Forms![LABLINEEXTRUSION1]![ResinA] = Me.Combo6

End Sub


Thanks

--
Message posted via http://www.accessmonster.com