I'm working on a database for a hair salon. On the data entry subform I would like to be able to select a service from a combo box (pulled from tblServices) and then have the corresponding price automatically appear in txtPrice on the form. I originally set the control source for txtPrice to be =cboServices.column(1). This works except that the stylist wants to be able to modify the price in txtPrice in case she wants to give a discount to certain customers. How can this be accomplished?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text box contents based on combo box contents yet still editable?
- Thread starter ashows
- Start date
Set the control source for txtPrice to be the corresponding field in the underlaying query/table.
In the AfterUpdate event procedure of cboServices:
Me!txtPrice = Me!cboServices.Column(1)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
In the AfterUpdate event procedure of cboServices:
Me!txtPrice = Me!cboServices.Column(1)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Status
Similar threads
