Auto-Populating a field in Access

[Thumper]

I have created a "Services" table in Access. Within this table I have a "Services Provided" combo box that lists various services I have populated in a "Products" table. I also have a "Default Price" field in the "Services" table. However, I would like for this field to auto-populate a value once a service is selected from the combo box. I have defined default price values in the "Products" table and am not sure how to have this data populated in the "Services" table.

Very grateful for any assistance,

Thanks

[PEB]

I have created a "Services" table in Access. Within this table I have a "Services Provided" combo box that lists various services I have populated in a "Products" table. I also have a "Default Price" field in the "Services" table. However, I would like for this field to auto-populate a value once a service is selected from the combo box. I have defined default price values in the "Products" table and am not sure how to have this data populated in the "Services" table.

Very grateful for any assistance,

Thanks

Hi,

In your combobox Services Provided, record source modify this property! Add the columns with the values as a second column!

In the column count property of the combobox modify the number of columns to 2

In the colum width property modify the size of columns

Width of the list specify the length of the columns together!

Finally in your After Update Event type the follow:

Forms!Services![Value]=Forms!Services![Services Provided].Column(1)

Have a nice day!

:)