Create a criteria/programming a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Exactly how do you get a combobox to appear in a Datasheet View form? Perhaps
you mean Continuous View? The link Piet provided is one good example and
there's gobs of others out there. The concept is called "cascading
comboboxes" and placing this in a search engine should bring you a slew of
hits.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
missinglinq via AccessMonster.com said:
Exactly how do you get a combobox to appear in a Datasheet View form? Perhaps
you mean Continuous View? The link Piet provided is one good example and
there's gobs of others out there. The concept is called "cascading
comboboxes" and placing this in a search engine should bring you a slew of
hits.
Click to expand...

If you use a ComboBox for a field in design view it will still be a ComboBox in
datasheet view.
 
Back
Top