IrwinHunter
Technical User
I am having a problem creating a form that will find a record in my database.
Background:
I am using Access 97 and Windows NT Service Pack 6.
I have created a simple reational database with one table containing addresses of suppliers and one table containing contacts for those suppliers (there are other tables too, but they're not really the problem).
I have a form with two sections seperated by a tab control. The first tab has the supplier details, the second tab has a sub form which displays the contacts for that supplier.
I want to create a facility whereby a user can search for a supplier or contact. If I use the 'Find' control from the standard buttons, it works with the supplier records on the supplier tab, but if I put it on the contacts tab, it only picks out those contacts related with the provider you've just tabbed accross from (as you might expect!).
I need users to be able to see other records related to the one they've searched for so a query by form wouldn't be acceptable. e.g. if a user is looking for a contact named Mr Smith, they may also want to see who the other contacts are and which supplier he works for.
Is there a way of doing this? Possibly from a form?
I've tried doing a macro that uses the find record facility and then opens the main form up, but it always opens it on the first record, not the one that matches the search criteria.
So in conclusion - I need to create a form into which I can enter search criteria for suppliers and / or contacts and then display the results within the main form.
I would really appreciate any help on this as it's driving be mad. From other stuff I've read on this forum, you lot seem to be on a much more advanced level than I am - PLEASE HELP!!!!
Thanx
IrwinHunter.
Background:
I am using Access 97 and Windows NT Service Pack 6.
I have created a simple reational database with one table containing addresses of suppliers and one table containing contacts for those suppliers (there are other tables too, but they're not really the problem).
I have a form with two sections seperated by a tab control. The first tab has the supplier details, the second tab has a sub form which displays the contacts for that supplier.
I want to create a facility whereby a user can search for a supplier or contact. If I use the 'Find' control from the standard buttons, it works with the supplier records on the supplier tab, but if I put it on the contacts tab, it only picks out those contacts related with the provider you've just tabbed accross from (as you might expect!).
I need users to be able to see other records related to the one they've searched for so a query by form wouldn't be acceptable. e.g. if a user is looking for a contact named Mr Smith, they may also want to see who the other contacts are and which supplier he works for.
Is there a way of doing this? Possibly from a form?
I've tried doing a macro that uses the find record facility and then opens the main form up, but it always opens it on the first record, not the one that matches the search criteria.
So in conclusion - I need to create a form into which I can enter search criteria for suppliers and / or contacts and then display the results within the main form.
I would really appreciate any help on this as it's driving be mad. From other stuff I've read on this forum, you lot seem to be on a much more advanced level than I am - PLEASE HELP!!!!
Thanx
IrwinHunter.