Autopopulating a field in a form

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hello,

I have a form that I use to put information into a table.
Several controls are combo boxes that I can select data
from a table. For example a list of employee's and
possible jobs. One of these combo boxes is the available
sizes for purchase. The next control is the price. I was
wondering if there was some way to type in the size of the
purchase and have the price automatically fill in.

Thanks in advance.
Amanda
 
Yes...But it taks a little coding.

on the AfterUpdate event of the combo box, you could tell
Access to populate the Price based on combo box value. I
do this quite often. I usually include the value in a
separate but invisible column in the combo box (set the
column width to 0"). my afterUpdate looks like this:

private Sub cbo_Size_AfterUpdate()
txtPrice = cbo_Size.column(2).value
End sub

hope this helps.
 
Back
Top