Requery or refresh - which to use

[pdit]

I have a combo box that I use to locate records in a form. I'm far (very far)
from an access export so I'm confused on why when I enter a new record, only
I am able to advance to the correct record. Others on the network are able to
see the name in the combo box but when they select it, it does not advance
the form to that name until they close out of the database and go back in.
Here is my code for the combo box. Is there something else I can add to make
the form refresh or requery (whichever one applies). The name of the form is
Arrest table Query.

Private Sub cboFindArrestID_AfterUpdate()
Me.cboFindArrestID.Requery
DoCmd.GoToControl "ArrestID"
DoCmd.FindRecord cboFindArrestID
DoCmd.GoToControl "LastName"
End Sub

 

[SteveM]

Try removing the requery line from your procedure and see what happens...

Steve

 

[pdit]

Now no one (myself or network users) can see a new entry in the combo box. My
code now looks like this. I'm sure it's something I'm doing wrong (either in
the combo box or the way I've built the form) but my goal is to have one
person entering data and other network users be able to locate the arrested
persons name in the combo box and then upon selecting that name from the
list, advance to that record on the form.

Private Sub cboFindArrestID_AfterUpdate()
DoCmd.GoToControl "ArrestID"
DoCmd.FindRecord cboFindArrestID
DoCmd.GoToControl "LastName"
End Sub

pdit

 

[pdit]

I apologize for the last posting - I was incorrect in my description. We are
all able to see the name in the combo box but the form on the network user
side does not advance to the record when selected from the combo box. The
form is pulling the data from a query which is why I thought it needed the
requery or refresh statement. Thanks again.