Show boxes if combo box field selected?

[alvarogueva]

Well;

Hey there.

I am trying to show or hide boxes depending of a selection in a combo Box.

For example:

If Chose in combo Box - Car

It will show fields - Make, Model, Color, Cylinder, Type of wheels

If Chose in combo box - Human

it will show fields - High, Year of birth, Type of sex, Religious significance, etc

Can this be done? Any ideas how? I search trough youtube and google and came up with nothing. :S

Thank you guys!!!

 

[MarkK]

You know those all-in-one tools that slice, dice, cube, grind, fillet, fry, zest, puree, whip, and chop? You know how they do everything, but they do everything crappy?

You don't want to start building a form like that. Make a form for a car with the fields from the Car table. Then, build a DIFFERENT form for the human, with fields from the Human table.

Hope this helps,

 

[alvarogueva]

You know those all-in-one tools that slice, dice, cube, grind, fillet, fry, zest, puree, whip, and chop? You know how they do everything, but they do everything crappy?

You don't want to start building a form like that. Make a form for a car with the fields from the Car table. Then, build a DIFFERENT form for the human, with fields from the Human table.

Hope this helps,

I see what you mean;

The whole intention is, for example, The Form for Cars. Not all cars have the same options, and not all cars have the same sets. So I wanted to be able to chose in the same form, different sets, depending of the car is chosen. do you understand what I mean?

 

[jdraw]

Do you have a list of requirements for your proposed database?
Have you tried to write - in plain English- the "things" that your database will manage?

Getting your tables and relationships designed and tested to meet your requirements is a key step before getting into forms.

Keep it simple as Markk suggested; then build on completed, working parts as needed.

Here's a link to a general approach to database design that may help.

Good luck with your project.

 

[alvarogueva]

Do you have a list of requirements for your proposed database?
Have you tried to write - in plain English- the "things" that your database will manage?

Getting your tables and relationships designed and tested to meet your requirements is a key step before getting into forms.

Keep it simple as Markk suggested; then build on completed, working parts as needed.

Here's a link to a general approach to database design that may help.

Good luck with your project.

I think you forgot the link;

Well yes I already incorporated the text boxes and relationships, the only thing I don't know how to do is to hide some while the others show, depending on section. But i will probably just leave it like that. it will be more useful I think

 

[jdraw]

You are correct -- I didn't post the link ---sorry.
Here it is:
http://www.databaseanswers.org/approach2db_design.htm