Jul 23 2004, 06:27 PM
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?
Jul 23 2004, 06:39 PM
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....
Jul 23 2004, 07:09 PM
Oh, that should work. I forgot that forms had datasheet view. Thanks, Jack!
Jul 23 2004, 07:34 PM
You can set the "RecordsetType" property of the form to make it non-updateable ...
Private Sub Form_Open(Cancel As Integer)
Me.RecordsetType = 2
Jul 24 2004, 10:50 AM
You are still teaching this old dog new tricks! Thanks Ricky!
I hope this finds you well, happy and not in Dripwater, Texas....
Jul 24 2004, 10:51 AM
You are welcome, but I like Mr. Hicks solution better... Use what works best for you.
Jul 24 2004, 01:59 PM
No, not in Texas ...
I have been home in Birmingham the past 3 or 4 weeks working on a project for another client.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here