db user can Search but not Amend

[DownhamC]

Can you perform a search (using a button) on a form that displays the result so that it can be used in a subform BUT the result fields cannot be amended.

I have a form searching a table with shareholder names and addresses which must not be changed...having found the correct shareholder a subform can be used to enter additional shares bought in another table.

Problem is how to stop the user accidentally amending the shareholder details table - if I disable the fields in anyway the search does not seem to work.

Any suggestions please?

 

[Adrianna]

So you've tried locking the fields in the form and that prevents the search from functioning?