Automatic Pricing

[Zharia]

I would like to set up my present form so that when I select a product from a list it will automatically put the pricing in. All the pricing would be from my products table.
Can anyone tell me how to do this as Ive tried many things with no success.

 

[Abby N]

There are a few different ways to do what want. At this point, with the form already created, the simplest would probably be to set the pricing fields 'Control Source' property as a DLookup. Something like:
=DLookUp("[Price]","Products","[Product] = " & [Forms]![Form Name]![Product])

See the help file for more information on DLookups. Hope this helps.

~Abby