Form Design

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

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
 
Hi Scott,
In my opinion, you have two choices.
1) do the form as you said and have accurate information that can be tracked
(how many quotes per product, etc) or,
2) allow the users to input the information per quote which will be full of
inaccuracies and variations.

Users do not like data entry. It depends on the resources available to you
and the way your business operates.. Do you drop/add products frequently?
Is there someone that can enter the brands into the database? Do you want to
track quotes per brand? What kind of reports do you want to generate from
the entries in the Quotes Module? Does anyone want the information that is
being entered?

I hope this helps.
Captain OhNo
 
Thanks Captain OhNo,

I have had a crack at option one but need a bit of VBA help.

Cheers,
Scott V
 
Back
Top