Do you have another table that is a master list of the Model, Make, Country or you just using the records in your one table? Let's say you are using the 1 main table. Create a combobox from table StonelCars, add fields: Model, Make, Country Of Manufacturer and NumberofTires, do a Totals/GroupBy on all fields so you get unique list, make sure the bound column is 1 to point to the Make field. Then in the AfterUpdate on this Make combo box, put this code:
If not isnull(me.Model) thenMe.Make = me.Model.column(1)
me.[Country Of Manufacturer] = me.Model.column(2)
Me.NumberOfTires = me.Model.column(3)
Me.CarYear.Setfocus
ElseMe.Make = null
me.[Country Of Manufacturer] = null
Me.NumberOfTires = null
Me.Model.Setfocus
End If
EDIT: Looks like aytee111 example is if you are trying to pull up a record(s) on the form based on Model, my code is if you are entering data into a recordon the form itself. You might need a combination of the 2 as you will want to add records but also look records up maybe by model type?