A set of two conbo boxes repeated in a form

PST

New member
Local time
Today, 00:21
Joined
Aug 2, 2005
Messages
9
I have a pair of combo boxes which are n a frm and work fine.
The code is:

Private Sub cboSubjectSelector_AfterUpdate()
Me!cboOneBookSelector.Requery
Me!cboOneBookSelector.SetFocus
End Sub
Private Sub Form_Current()
Me!cboOneBookSelector.Requery
End Sub

I want the combo boxes to be repeated five more times so that the same options are given within the same form. Every time inset a copy of the same combo box get the folowing error message:

'Microsft Access can't find the macro 'requery''
I am ot sure what I need to do nrder t remove the error message. I did not create a macro called 'requery' tis part of the code above.
I have alos tried to recopy the code above and then retnamed the cbo in the form adn then modified then copied and modified the code to see if that helps - it doesn't. Any ideas - please help.
 
Well here is my two cents worth, I usually put my .Requery in the control's GotFocus event. I think that it is the Form's OnCurrent .Requery that is causing the error. Try commenting it out. hth.
 

Users who are viewing this thread

Back
Top Bottom