Search in specific field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to refine my abilities to search within the records with a
command button in form view. I need it to only search in the PRIMARY KEY
field. not in the field which the cursor is in...
 
I would like to refine my abilities to search within the records with a
command button in form view. I need it to only search in the PRIMARY KEY
field. not in the field which the cursor is in...
Click to expand...

How does Access KNOW which PK value to go to?

Using an InputBox?

If the PK field is a Number datatype then, for example:

Me.RecordsetClone.FindFirst "[PKFieldName] =" & InputBox("What
value?")
Me.Bookmark = Me.RecordsetClone.Bookmark

If the PK field is a Text datatype, then:

Me.RecordsetClone.FindFirst "[ID] = '" & InputBox("What value?") & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

You can adapt the above to a Control on a form to input the value to
be searched for...
Me.RecordsetClone.FindFirst "[PKFieldName] = " & Me![ControlName]
 
You must log in or register to reply here.

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

Setting the Focus on a Specific Field after clicking "Add Record" 2
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
Searching/Filtering Form by Date Calendar: Week Beginning... 1
MS Access problem 0
Find Record in Subform 1
The changes you requested to the table werenot successful ........ 1
Force Autonumber to generate 0

Back
Top