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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery Form 1
Setting default value property in form 1
access97 to 2002 search button conversion error 1
Manipulate Find Replace Dialog Box using Code 4
Access 2007 newbie with Form Issues 1
Go to same Record/ Syntax Error 8
Write Conflict Occurs on Me.Requery 1
DIALOG FORM SIZE 2

Back
Top