Form possibilities

[Scott Viney]

Hi All,

This has me a little bit stumped at the moment. I have a form with my
customer details in which is a subform for the quotation details. On this
form also is a command button that when you press, opens another form to
show the details for the quotation. Up until this point I have it working.

The problem I am having is what is the best way to add the quotation details
to this other form. My idea at the start was to have a datasheet. The user
first
selects the brand, then the next column would have a combo box list all that
brands products. The user then chooses the correct item and the prices etc
fill out.
But I just dont know how to get it to do it. There could be 100s of
products for
each brand. It seems uncomfortable to do it this
way.

Is this the best way or can someone suggest some other better solutions.

Cheers,
Scott V

 

[Linda Burnside]

To do something similar to this, I have used some unbound combo boxes. The
user inputs values in to the unbound boxes (such as a quotation and a
product). After providing the information, the recordset is changed to
values which match those entered values. Easy to do if you use a query or
SQL statement as the recordsource.

Linda