Hey,
I have a question but can't seem to find an answer to it: Is it possible to navigate to a particular record of a table without applying a filter to the form?
This is how my forms are set up: On the form used to edit Supplier details there is a combo box that is used to navigate directly to another supplier. I set up a button (using the wizard) that went to the form and opened the record that matched with the selection in the combo box. But the problem with this method is that the results are filtered; if you then want to go to the next record you have to un-apply the filter then you can continue navigating through forms using the form nav buttons at the bottom of the form (which is probably a bit too complex for the end-users of the database).
There must be a better way to do this.
I have a question but can't seem to find an answer to it: Is it possible to navigate to a particular record of a table without applying a filter to the form?
This is how my forms are set up: On the form used to edit Supplier details there is a combo box that is used to navigate directly to another supplier. I set up a button (using the wizard) that went to the form and opened the record that matched with the selection in the combo box. But the problem with this method is that the results are filtered; if you then want to go to the next record you have to un-apply the filter then you can continue navigating through forms using the form nav buttons at the bottom of the form (which is probably a bit too complex for the end-users of the database).
There must be a better way to do this.
