Form Default value...newbie alert!

[AndyD]

Hopefully someone can help me with what is probably a simple problem.

I have a form where the user looks up products with a Combo Box, the data is derived from a product "look-up" table (part no. description, retail price etc). This information is then stored in another table to show sales along with customer info.

The "look-up" table has a retail price for each product whish is fixed. I would like the form to put this value in the sales price field by default, then the user can adjust this price if required or just accept the "auto entered" retail price.

How do I do this... probably simple, but i'm new to all this.

Thanks

Andy

 

[RuralGuy]

In the AfterUpdate event of your ComboBox put:
Me.txtPrice = Me.ComboBox.Column(2)
...using your control names of course and remember that the Column value is zero based so 2 is actually column 3.