Bookmark feature on a data entry form

[Belinda7237]

I have a data entry form and wanted to use the bookmark feature to allow for
managers to lookup or access a completed form. it seems the bookmark only
works for the most recent entries but when you go out of the database and
back in the bookmark doesnt seem to work.

In an unbound field on the form I have the following:
Private Sub Combo906_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[StatsPackageNumber] = " & Str(Nz(Me![Combo906], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Am I missing something?
Thanks

 

[Jeanette Cunningham]

Belinda,
if your form is for data entry only and when you open the form it is blank,
then the find first method won't work.
For find first to work, the form needs to have its Data Entry property set
to No.
You might find it easier to have another copy of this form with both its
data entry and allow edits set to no.
You could use the find first method on this form.
On your data entry form, put a button that opens the second form for the
managers to check on past entries.


Jeanette Cunningham -- Melbourne Victoria Australia