P
Peter Papadimitriou
Hi there
I would like to use option buttons on a form to do as follows but don't know
how.
The option buttons select a product (eg Product A, B or C)
This product is then used as the Field Criteria for a Query.
I then want to display the resultant Query in a datasheet in a subwindow.
It will work like this. When I click on Product A option button, I will
see a table of information about this product in the subwindow in datasheet
format.
Similarly when I click on Product B and Product C.
I would also like to include and option button 'Products ALL' which would
list
details about Products A,B,C at the same time.
Ideas, comments code welcome.
thanks
Peter
I would like to use option buttons on a form to do as follows but don't know
how.
The option buttons select a product (eg Product A, B or C)
This product is then used as the Field Criteria for a Query.
I then want to display the resultant Query in a datasheet in a subwindow.
It will work like this. When I click on Product A option button, I will
see a table of information about this product in the subwindow in datasheet
format.
Similarly when I click on Product B and Product C.
I would also like to include and option button 'Products ALL' which would
list
details about Products A,B,C at the same time.
Ideas, comments code welcome.
thanks
Peter