open form with dialog box

  • Thread starter Thread starter Cyndi
  • Start date Start date
C

Cyndi

is it possible to make a dialog box that would open a form to a particular record

example


find record ______________________


open form button close

If so how do I do it
 
Create a command button & add this to the click event for the button:
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[OBJECTID] = " & InputBox("Enter a Code", "Find Record")
'Str(Nz(Me![Combo10], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
 
Back
Top