form view with multiple combos

[AdrianoG87]

Hi All,
MS newbie here and i've hit a brick wall.



i've been doing a project at my work for some time now and ive been learning access as i go along but im stuck at the first step of my next project.

I have a query that displays customer name - freight carrier - zone - price ect ect. all fields have repeating values, what makes a record unique is the combination of the values.

i need a form that displays each field as a combo box that limits the next box results and so forth. similar concept to using filters in excel but in a nice user friendly form view.

not all customers have all carriers and not all carriers go to the same zones, and not all customers have the same pricing to the same zone as another customer. very complex.

i tried using a previous forum thread to solve the problem, (badly cascading combobox it was refered to as) but where those combos point to a table, i need mine to point to a query. (also when i make a combo box, the results of that field dont display at all which is confusing me)

please help. and please keep it simple. i really dont understand any of that SQL stuff or coding etc.

if anyone could also point me to a sample DB i can download, that'd also help alot.

any help would be appreciated.

thanks all.

[June7]

That is dependent (cascading) comboboxes. Check this tutorial http://www.datapigtechnologies.com/f...combobox2.html

Can point to a query just as well as a table.

Are these comboboxes in form set for Datasheet or Continuous view?

[AdrianoG87]

thanks buddy, i'll give it a whril.
the combos are on a single form view.