I have a combo box that filters another combobox on a form after i do
a requery. The issue is that i don't want my form to return to record
one when i do the requery. Is there an easy way to keep it on the
current record. I am not a vb expert by any stretch of the
imagination.

thanks,
KO

koturtle wrote:

Because Requery goes back to the table to resync the records
with any actions (new, deleted and updated records) by other
users, the form's recordset can conceivably be totally
different from before the Requery. IOW, the record that was
current before the Requery may be in a different place or
not even exist after the Requery so the first record is a
logical record to become the current record.

You can use some fairly simple code with the Requery to
remember the current record's primary key before and
relocate that record after the Requery:

DIm PK As Long ' type of primary key field
PK = Me.[primary key field]
Me.Requery
With Me.RecordsetClone
.FindFirst "[primary key field]=" & PK
If Not .NoMatch Then
Me.Bookmark = .Bookmark
Else
MsgBox "record no longer exists"
End If
End With

If you can guarantee that the current record can not be
deleted by abither user, the code can be sinplified to:

DIm PK As Long ' type of primary key field
PK = Me.[primary key field]
Me.Requery
Me.Recordset.FindFirst "[primary key field]=" & PK

--
Marsh

"koturtle" <kolsby (AT) gmail (DOT) com> wrote

Do you really need to requery the whole form, or just the filtered combo box
on its "On Enter" event ?

On May 3, 5:17*am, "aceware" <acew... (AT) iinet (DOT) net.au> wrote:
Marshall's answer is sometimes what you have to do. But, I agree with
Ace. You could probably save yourself the first requery by having the
first combobox only update the second.

Jon