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
Graham R Seach - 09 Feb 2005 12:33 GMT
Peter, this has been answered in the Access group. Please don't multi-post.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
> Hi there
>
[quoted text clipped - 19 lines]
> thanks
> Peter