When going from one form (e.g. the index) by selecting a record and hitting a goto button, the database brings up another form in a filtered view. I need to be able to open this new form, with the selected record NOT filtered, and hit a next button to traverse through following descending records. Currently, when it opens the record, with filtered view, hitting the next or back button brings up an error dialog box (e.g. 'You can't go to the specified record. You may be at the end of a recordset')
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
From an index, open a record in an un-filtered view
- Thread starter rpmtech
- Start date
What do you mean by "next descending records"? The records following the selected record when the records are sorted in a particular way?
If so, you could base your second form on a query where the query has a criteria of >= selected value.
Does that sound like what you are looking to do?
If so, you could base your second form on a query where the query has a criteria of >= selected value.
Does that sound like what you are looking to do?
- Status
Similar threads
- Locked
- Question
- Locked
- Question