Create a criteria to combobox

[Marco]

Hi. I have a form in datasheet view. there's a combo named Hardwaretype and
another one named hardwarename

there's a table with hardtwaretypes and another with hardwarename and also a
relationship between this two tables. : one hardwaretype has many
hardwarename.

In one recorset of that datasheet view form if I choose monitors in
hardwaretype
combobox, I want that in hardwarename combo only appeares the hardware that
belongs to monitors, such as CRT; LCD.

If the next line I choose Printers on hardwaretype I want that that in the
hardwarename
combobox only shows me the hardware that belongs to prints. ie: laser,
matricial, inkjet,....

It's a criteria of what is choosed on hardwaretype.

Is it possible?

Regards,
Marco

 

[scubadiver]

This is one of the most common questions asked. Search for "cascading combo".