Automatically focusing on a newly created record

[agt119]

Upon closing one form, I'd need a specific item in another form's list to be selected.

Basically:
Form A: main form, lists all records in db
Form B: new record creation form

Upon saving/closing Form B (thus returning to form A), is there a way for the newly created record to be selected in form A?

Thanks in advance!

 

[Remou]

You can use the RecordsetClone of Form A from Form B:

Set rs = Forms!FormA.RecordsetClone
rs.FindFirst "ID=" & Me.ID
If Not rs.NoMatch Then
    Forms!FormA.Bookmark=rs.Bookmark
End If

 

[agt119]

Thanks very much for getting back to me Remou!

When I tried this, the line

Forms!FormA.Bookmark=rs.Bookmark"

gave me an error "not a valid marker".

Form B is a subform -- might that be the problem? Do you know what I can do about this?

Thanks a lot!

 

[agt119]

I forgot to say that, as FormB is a subform, what I tried to do was:

Forms!FormA!FormB.Form.Bookmark=rs.Bookmark

instead of

Forms!FormA.Bookmark=rs.Bookmark

Thanks a lot!

 

[Remou]

I missed a requery I should have included, but that does not seem to be the problem. When you say 'subform', do you mean a small form that pops up or a form embedded in FormA? Also, please post the code as amended by you for your application.

 

[agt119]

FormB is embedded in FormA.

Here's the code I added on FormC close. Here FormC is another Form, from where I create the new record, to be shown in Form B.

'on FormC close
Private Sub Form_Close()
Forms![FormA].Recalc
Set rs = Forms![FormA]!FormB.Form.RecordsetClone
rs.FindFirst "order_pk=" & Me.order_pk
If Not rs.NoMatch Then
Forms![FormA]!FormB.Form.Bookmark = Me.Bookmark
End If
End Sub

The bold line is the one which causes the error

 

[agt119]

Maybe a better explanation here, would help.

Form B is embedded in Form A. I open FormC and create a new item. Then upon closing Form C, FormA and its sub form (FormB) should be refreshed, and Form B should show the new item recentrly created from FormC.

Thanks Remou!

 

[PHV]

Forms![FormA]!FormB.Form.Bookmark = [!]rs[/!].Bookmark

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[agt119]

Thanks PHV! that definitely solved the problem. However, it still doesn't go to the recently created record.

Maybe there's another way of doing it? like going to the last updated record? I've seen there's a LastUpdate property in the rs recordset...

Thanks a lot for your help