Filtering Records in Statement Opening Form

  • Thread starter Thread starter Frank Wagner
  • Start date Start date
F

Frank Wagner

I need to open a form and filter the records to a specific "relative record
number" based on a randomly selected number. I use Access 2000 and know how
to "Go To" a selected number, but I don't know how to filter records so I
only receive that record number.

Any help would be appreciated
 
You can't filter on a relative record number. It is not part of the form's
recordset. You can only filter on fields in the form's recordset.
 
1. go to the record,
2. grab a value from a unique identifier field (indexed with duplicates set
to no)
3. build a WHERE statement string based on this value
4. apply the string to the form's filter property
5. set the form's filteron property to True.

You'll need to be able to code this in VBA to get it to work .
 
Back
Top