Subform Combobox Update

T

Tanya

Hi I have finally gotten my combo box's working, however when I brought my
new form across as a subform it is trying to requery but as soon as I select
the tab on my form with the subform Goal I am prompted for information.

An earlier post mentioned adding the form name something like this

Me!Goal.Form!Target.Requery

but that didn't help. any suggestions welcomed.

Here is my code for the form named Goal


Option Compare Database


Private Sub cboFocus_AfterUpdate()
cboFocus.Requery
Me.cboTarget = Me.cboFocus
Me!cboTarget.Requery

End Sub

Private Sub cboStrategy_AfterUpdate()
cboStrategy.Requery
Me!cboTarget.Requery

End Sub

Private Sub cboTarget_AfterUpdate()
cboTarget.Requery
Me.cboStrategy = Me.cboTarget
Me!cboStrategy.Requery
End Sub

Regards
Tanya
 
Top