Form showing info pulled from a query...

[ianforest]

Actually, I don't think i've done this right, but here's the goal I wish to achieve.

I have 2 tables, one containing contract info and another containing client info. I have the 2 related using the client name field. I have a form which is based on the contract table which contains a drop down field of client names. When I select a client, I want it to update a read only client address field within the form, just for display purposes.

Is this easy to do and can anyone point me towards some examples on how to achieve this???

Many thanks.

 

[Jibbadiah]

Do a query that has all of the fields that you require for the form.
Make the form based on your query rather than the table (... on record source).
Open the form in display view. Right click on the address control and make it locked.
This will let them view the address, but they can't update it.

James