Filtering Records in Statement Opening Form
in [Forms]
|
Prev: ehrenamtliche arbeit im ausland bonn ausland arbeiten im ausland krankenschwester arbeiten im ausland sozialversicherung
Next: Drop down menu not functionning after upgrade to 2003
From: Frank Wagner on 3 Jul 2008 12:11 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 -- Frank Wagner fwagner111(a)aol.com
From: Klatuu on 3 Jul 2008 12:34 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. -- Dave Hargis, Microsoft Access MVP "Frank Wagner" wrote: > 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 > -- > Frank Wagner > fwagner111(a)aol.com
From: Frank Wagner on 3 Jul 2008 12:46 Klatuu: That answers the question. Thanks -- Frank Wagner fwagner111(a)aol.com "Klatuu" wrote: > 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. > -- > Dave Hargis, Microsoft Access MVP > > > "Frank Wagner" wrote: > > > 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 > > -- > > Frank Wagner > > fwagner111(a)aol.com
From: JString on 5 Jul 2008 21:59 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" wrote: > 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 > -- > Frank Wagner > fwagner111(a)aol.com
From: Frank Wagner on 6 Jul 2008 15:13
Thanks. I have such a field, and I'll try it out -- Frank Wagner fwagner111(a)aol.com "JString" wrote: > 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" wrote: > > > 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 > > -- > > Frank Wagner > > fwagner111(a)aol.com |