Access VBA Opening Form to display specific record without filter
I need to get a form to open another form and display a specific record. BUT I don't want to apply a filter because the user needs to select any record if they don't want the specific one that is displayed.
I have tried opening the form with a LinkCriteria that selects the records I want (and that works), but if I then remove the filter (forms!formname.filteron=false) the filter is removed but the form jumps to the first record in the database.
The form has an 'OrderBy' on it and I can't take that off because the form sequence would then make no sense to the user.
This is one of those 'this should be simple but I am damned if I can find the answer" questions.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.