range names or check box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have list of products that are tied to rates.
one product has 5 rates and the second has 10 rates.
The product is chosen by a drop down box
I have a lookup to create a table with the rates- this is range named "rates".
I have a drop down box linked to "rates" so a customer can choose the
product and the rate with drop down boxes.

My issue is that if the product with 5 rates is chosen then you have a 5
blank rows in the rate drop down box. Is there any way to link the drop down
to 2 different range names - based on product - or is there some better way
to do this ?

Thanks,
Yosef



.

Relevant Pages

  • Re: range names or check box
    ... KK - The problem is I used Combo boxes not validation. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Strange
    ... I have a Form that looks up Customer information via a number of Combo ... The Text Boxes are Bound to the Customers Table and the "find" combo ... Public Function util_ShowInfo(frm As Form, strField As String, varInfo As ... strCriteria = BuildCriteria ...
    (microsoft.public.access.gettingstarted)
  • Re: display results from combo/ narrow list as typed
    ... How many columns are you showing in the property for the combobox? ... I have 2 combo boxes on my customer maintenance form. ... typing in a part # starting w/ P, then I want the box to show ONLY those ...
    (microsoft.public.access.formscoding)
  • RE: Search facility query
    ... I have put the three boxes on the main form. ... The name of the control on the main form for customer name ... The name of the table or query that is the record source for the main form. ... Set rstClone = Me.RecordsetClone ...
    (microsoft.public.access.modulesdaovba)
  • display results from combo/ narrow list as typed
    ... I have 2 combo boxes on my customer maintenance form. ... the shipping locations for that customer. ...
    (microsoft.public.access.formscoding)