Filtering Records in Statement Opening Form

[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

 

[Klatuu]

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.

 

[Frank Wagner]

Klatuu:

That answers the question. Thanks

 

[JString]

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 .

 

[Frank Wagner]

Thanks. I have such a field, and I'll try it out