JoAnn,
I'd suggest creating a new table to store your services and the rates you
charge for them:
tblService
Service (Text, Primary Key)
Rate (Currency)
Then, add a combo box, called cboService, to your form, and set its
RowSource as follows:
SELECT * FROM tblService ORDER BY Service
Bind the combo box to the rate field in the form's underlying table. Set the
combo box's other properties as follows:
ColumnCount: 2
ColumnWidths: 2cm;2cm
Then in the combo box's AfterUpdate event, add the following code to
populate the txtRate textbox:
If Me!txtRate = Me!cboService.Column(1)
Then add the same code to the form's Current event.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
>I have a form that I would like to autofill on field if another field meets
>a
[quoted text clipped - 6 lines]
> the service field?
> JoAnn
jkjmwilliams - 23 Mar 2007 16:09 GMT
Thanks! I've been trying to figure out how to do that for a long time and
asked everyone I knew. I tried it, and it worked.
> JoAnn,
>
[quoted text clipped - 34 lines]
> > the service field?
> > JoAnn