Model number combobox population

[nplamondon]

I'm trying to create an equipment tracking db in Access 2003. I have
a form with equipment type (server, kvm, patch panel, etc), make
(dell, hp, etc), model (string value), size (numeric value)

I currently have Model being stored in tblServers and the form should
populate the other fields (type, make, model, size) from tblModel,
based on the value of Model.

When I try to set the control source for any of these fields (example:
=[tblModel]![Type] ), I get the error:

The object doesn't contain the Automation object 'tblModel.'

After hours of tinkering, reading and googling, I'm becoming
frustrated. How can I populate these fields? Thanks in advance for
any assistance.

 

[Klatuu]

First, you need to make your form a Bound form and the controls on the form
bound controls.
That is, with the form in desing view, open the properties dialog for the
form, select the Data tab, and in the Record Source property, select either
your table or a query based on your table.
Then use the same procedure for each control on your form, but instead of
the record source property (controls don't have them), select the Control
Source property and select the field that you want to show in the control.