Hi All
I am very new to Access and currently experimenting with setting up basic database.
I need to search for a record with a unique indexed number (no Dups) via a command button on my main form.
Ideally the search will then take me to the corresponding row displayed in a sub-form.
I would assume that i acheive this via a query and the paramaters options but I am unsure about the how to and displaying the results in a new form?
Any help????
I am very new to Access and currently experimenting with setting up basic database.
I need to search for a record with a unique indexed number (no Dups) via a command button on my main form.
Ideally the search will then take me to the corresponding row displayed in a sub-form.
I would assume that i acheive this via a query and the paramaters options but I am unsure about the how to and displaying the results in a new form?
Any help????