creating forms

  • Thread starter Thread starter Samaa
  • Start date Start date
S

Samaa

sorry if my question seems long and basic as i am a beginner @ access
i have a list of items price list that include several columns of categories
and types .... etc.
i have imported the list to access and want to know how to creat a form with
objects that enable me to choose from the several drop down lists field and
the next fields gets filtered automatically according to the selection.
Example:
I choose the car brand then when i go to the model field only the models
related to this car barnd is visible and when i select the model and go to
the options field only options avilable for this car model is visible ... and
so on
 
sorry if my question seems long and basic as i am a beginner @ access
i have a list of items price list that include several columns of categories
and types .... etc.
i have imported the list to access and want to know how to creat a form with
objects that enable me to choose from the several drop down lists field and
the next fields gets filtered automatically according to the selection.
Example:
I choose the car brand then when i go to the model field only the models
related to this car barnd is visible and when i select the model and go to
the options field only options avilable for this car model is visible ... and
so on
Click to expand...

This is called a "Conditional Combo Box" - since the values for the options
depend on the model. Try using http://groups.google.com in advanced search
mode to search for Conditional Combo for lots of examples. For a short answer,
you would have a combo on your form (cboModel let's say) which selects the
model; also on the form you would have a combo, cboOptions, based on a Query
with a criterion

=[Forms]![YourFormName]![cboModel]

to limit the rows to those appropriate for that model, based on a table of
options.

Here are some resources that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top