Hi,
I'm using Access 2000.
After a very very very long time i've manged to crack my first QBF! When I click the command button to run the macro and display the results, the results are coming up in a table format.
Is there any way to have the results of the QBF displayed on the same form?
For example, if I have a table that contains my different products and their categories - in this example 50 different types of "toy trucks", 75 "toy cars" and 100 "toy trains" - and I then perform a QBF on the criteria of product type, in this example "toy cars" - I would want the first "toy car" record to show on the form in their relevant fields, and be able to scroll through 74 records before coming to an end.
This way I could easily place all my products in one table, then select which products I'd like to view in the form and scroll through them.
Any help would be greatfully appreciated as I haven't been able to find anything online.
Thank you in advance.
I'm using Access 2000.
After a very very very long time i've manged to crack my first QBF! When I click the command button to run the macro and display the results, the results are coming up in a table format.
Is there any way to have the results of the QBF displayed on the same form?
For example, if I have a table that contains my different products and their categories - in this example 50 different types of "toy trucks", 75 "toy cars" and 100 "toy trains" - and I then perform a QBF on the criteria of product type, in this example "toy cars" - I would want the first "toy car" record to show on the form in their relevant fields, and be able to scroll through 74 records before coming to an end.
This way I could easily place all my products in one table, then select which products I'd like to view in the form and scroll through them.
Any help would be greatfully appreciated as I haven't been able to find anything online.
Thank you in advance.
