Hi, everyone.

I've set up queries for my department to use when they want to look at and sort large set of information (as opposed to search forms when they want to look up just one thing). I don't want them to be able to edit the information in the queries, however.

Is there a way to make a query uneditable without affecting forms that source back to the same table? OR...is there a better way to approach this?

You can base forms on the queries and lock the indiviual controls on the forms and this will prevent users from changing the data. This obviously affect the forms but I can't think of a way to use a form without making some changes to it....

hth,
Jack

Oh, that should work. I forgot that forms had datasheet view. Thanks, Jack!

You can set the "RecordsetType" property of the form to make it non-updateable ...

RDH

You are still teaching this old dog new tricks! Thanks Ricky!

I hope this finds you well, happy and not in Dripwater, Texas....

Jack

You are welcome, but I like Mr. Hicks solution better... Use what works best for you.
Jack

LOL ...

No, not in Texas ...
I have been home in Birmingham the past 3 or 4 weeks working on a project for another client.

RDH