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

This is already posted in the Forms forum.

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

Col

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