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!

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."

"Samiullah" <(E-Mail Removed)> wrote in message
news:A309768B-BE20-4AE5-A331-(E-Mail Removed)...
>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!