Possible: 2 forms from one database with part greyed out on 2nd from from first.

[shadowsedge]

I made a form where one department fills out the 1st part of a form.
Once done, they submit it and it goes to another for response.



Is it possible to have a 2nd form with the information from the 1st form on it but grayed out so they can't make changes but can read and respond?

If it is possible, how would I accomplish it. Is there a better way? Still learning so I do not know all the ins and outs.

[John_G]

For all the controls you want greyed out and locked, set the Enabled property to No.

[Missinglinq]

And you can do that easily, without having to go to each individual Control, like this:

In Form Design View

1. Hold down <Shift> and Left-Click on each Control, in turn, that you want greyed out.
2. Right-Click
3. Click on Properties
4. Go to the Data Tab and set Enabled Property to No

You're done!

Linq ;0)>

[shadowsedge]

Sweet, works awesome. ty both.

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>