Make a Form with drop down selections

[Pauly78]

Hi all,

Could anyone help me?
Im trying make a form that will help me with my prices, basically i would like a form that has a series of drop down selections and after choosing them i get my price.
So for example, i have a table with brands - we'll say car brands, so the brand is one field, then i have a price band as another field, then i have a series of different fields with different jobs and the price for that job, such as service, engine oil, valet etc. So what id like to accomplish is my first selection is to choose the brand, then based on the brand only show any models associated with that brand, then in the next selection show a rop down of different services available, when i choose this i then get a price (which is already specified somewhere.

Can all of this be placed in one table, or should i make different tables? any help would be greatly appreciated. Let me know if i need to give any more specifics

Thanks

 

[Ranman256]

You should have 1 table, tPrices.
This will have everything, brand,produce,price.
Then a cboBrand will select the brand,
Then cboProd will show only products for that brand, until you pick the price.

 

[Pauly78]

Thanks for that, I've tried do do this, but it doesn't seem to work, do I need any vba?