Create a criteria/programming a combo box

[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

 

[pietlinden]

Requires magic, animal sacrifice, and ... a little bit of code...


sea hear <ocean roar>

http://www.mvps.org/access/forms/frm0028.htm

 

[Uysal YILMAZ]

Dear Marco,

Of course, it's possible.

you have to synchronize the comboboxes. You can find the solution to link
below:
http://msdn2.microsoft.com/en-us/library/bb243783.aspx

That article mentions about MS Access 2007, however it works on older
versions of MSAccess

Kindly Regards,

Uysal YILMAZ
Webmaster and MS Access Programmer

 

[missinglinq via AccessMonster.com]

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.