make a quote sheet that automatically enters in discription and pr

[Guest]

I am trying to create a template quote sheet that will automatically put in a
discription and price of the item entered.

 

[Terry]

Hi,
I'm making assumptions here about the design of your tables.

Say you have a table called tblItems and in it you have the primary key, an
item number, item description and price.

In your quote sheet you could use a ComboBox who's recordsource is based on
the tblItems table.

Depending on what field you want returned from the ComboBox, perhaps item
number, or it's primary key, you could also use code in it's AfterUpDate
event to get the description and price and fill the corresponding controls
on your form.

Hope this helps.
Regards