Hello,
I haven't been able to locate this by searching, but I imagine it is easy to do:
The User clicks a button that inserts a new record into the Database through SQL.
I need to show this new record in the form.
I think I need to do this, but am missing the specific code to position the record correctly
1: insert record into DB with VBA function, return the Primary Key
2: Refresh the Form so that it has visibility to the new record
3: Position the form on the returned Primary key.
I can do 1,2 only how do I perform 3?
thanks.Code:Private Sub cmdAddNewPart_Click() Dim lNewID As Long '---Add Part lNewID = CreateNewPart(txtPartFilter) '---Refresh Form Me.Refresh '---Position new record '??? End Sub
Steve