How do I get the combo box to link with costs field in the table?

[Samiullah]

I have a database which I am trying to figure out. I have a field in the
table which is the names of the cars and there is a price field. How do I
link both of them up so that when I create a form and select the different
car the different prices can appear.

Can someone offer some help with this Please!

 

[Al Campagna]

Samiullah,
We can't help until we know how you have your table set up.
Is the CarName and the CarPrice in the same table?
If they are in different tables, do you have a unique key field in each
table that "relates" the CarName in one table with a CarPrice in another?

I'll assume both fields are in the same table.
I'll also assume that when you say "I select a CarName" you mean via
a Combobox or Listbox.

Is this correct so far?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."