Combo Boxes and Fields

[Dale Cleeve]

I have a number of fields stored in a query, these are : Model Type, Price, Deposit and Balance.

I want to set the 'Model Type' field as a Combo Box, so when I select a record from the cbo box it will automatically bring up the rest of the data from the query for that particular record.

Do I need to add Unbound fields for this, if so - How do I setup the whole think?

I appear to be going around in circles - HELP!!

 

[arickards]

Use an unbound combo text box on the form. In your query insert this for the criteria [Forms]![FormName]![Modeltxt].
For the row source, link it to the table and column that contains your models. If that does not work simply make a seperate table that contains individual models and make that your row source.

HTH
Ash~