Query to Return Default set of values in a subform when main form opens

[hansnyc]

Here is my sample DBA

I'd like to solve this issue

when I open my Quotations form I'd like a set of services to be selected by default, ex: Brush and Pen. So the user only has to input the quote amount

is there anyway to have the form open with a script like:
"on open (or on load). in subform SELECT refproduct where product from tblproducts = 1 and also SELECT refproduct where product from tblproducts = 4"
Therefore when my main form opens, in the subform I have already Brush on the 1st line selected and pen on the 2nd. My user only has to type the price.

Thanks for your much appreciated help

 

[ColinEssex]

This is already posted in the Forms forum.

Don't multi-post, it leads to confusion.

Col

 

[hansnyc]

yes I was told by the administrator
Sorry about that, I wasnt sure where to post the issue.
Do you have any idea on the matter?
Thanks

This is already posted in the Forms forum.

Don't multi-post, it leads to confusion.

Col