How to requery another object on another form?

[blyxx86]

I can't seem to get this figured out. I am trying to requery another form after adding new information to a table that a cboList is created from.

So, I have a combo box that has Sales personnel, and i have another form that lets me add sales personnel to the table of all the sales team. (Name, number, etc...)

But when I open up the main form (with the combo box of Sales Personnel) and then open the form to add new members, or edit the members, I can not seem to make a piece of code that will requery the main combo box.

I have tried the following with no success...

Private Sub Command15_Click()
Dim cboSales As Control
cboSales = Forms!Main.Sales
cboSales.Requery
End Sub
 

Run time error '2465'
That doesn't work.

I tried...

Private Sub Command15_Click()
Dim Forms!Main.Sales As Control
Forms!Main.Sales.Requery
 
End Sub
 

That one is just filled with errors.

I tried to do a:

Private Sub Command15_Click()
Dim testReqSale As String
testReqSale = Forms!Main.Sales
DoCmd.Requery(testReqSale)
 
End Sub
 

Again, no success and more errors.

I suppose I could put a Requery command on the link to the form to add sales personnel, but that seems ineffective and the form could be possibly opened otherwise.

[MSeda]

I know I'm jumping in kind of late here, but have you tried setfocus. In order to requery an object the form it's on has to have focus.

Try

Private Sub Command15_Click ()

Forms![Main].SetFocus
DoCmd.Requery "Sales"

End Sub

[NeoPa]

I just place that in front of the other code, correct? I appreciate the help on this.

Yes.
But you should really have an

On Error GoTo 0

afterwards as well.
See the help on this (mainly posted above but in full from Access VBA Help) as it's very important to understand (and to use).