Forms

[Barbara Sherman]

If I need a form field to pull data from a table or query based on the answer to an above form field, how is this done? For example...If I select a particular make of vehicle and in the next field I am to choose the model (and, of course, I need the models in the drop down list to be models of the Make in the above field), how do I get this to occur? There are multiple makes and thereby multiple models in the tables. Please help?

 

[Sam Summers]

Hi there

This may be of help or some guidance.....

The way that I have in mind is to either hard code the options by using an if statement or by making the appropriate combo box visible depending on the text selected in the previous field.

Does this make sense?
If not tell me and I'll clarify myself.

Someone else may have a better idea though.