autopopulate based on row and field coordinate

[jenny6]

Hi,

I have several forms which will be similar in scope and content. Each form will represent a service that we perform and will contain the client's name, billing info and itemized list of procedures performed and their quantities. The form will extract information from three different tables, and the pricing is based on three different categories, public, academic and private.



So here's my question. How can I autopopulate all of the pricing information fields on the form based on a single selection made in the form? The form field on which I would like to base the rest of the pricing-related fields is going to be the Price_Scheme. Basically, the user would choose the relevant service from a dropdown and all of the other fields will automatically be filled in with the proper price scheme, i.e. public, academic or private. It would be ideal if I can do it all in one action, but I don't mind entering an expression for each individual field if necessary. I attached the two relevant tables.

I am not an experienced Access user, by the way.

Thank you in advance!

[Rod]

Ask this of 9 Access experts and you will get 10 different answers.

You need to give much more information about your Access design if you want specific help - or perhaps you are still at the design stage in which case we can try for an optimal solution.

For now be reassured that this can be done and is what computer applications are good at.

Post back and describe how far you've got. Tell us about your database design and form design.