By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,306 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Odd Behavior of entry fields (not allowing edits...)

tdw
100+
P: 206
I have a form which, when originally created, was solely for the purpose of viewing an order, not editing it (there was a different form for that), so the Allow Edits property was set to "No". But today I added a few new fields (mostly check boxes) to the table, and to the form as a tool to track the progress on an order. Since I wanted those new check box fields to be easy to use, I put them on the View Orders form instead of the Edit Orders (View Orders is the most commonly used form). I changed the form's Allow Edits property to "Yes". Allow Additions is still set to "No." Then I individually locked each of the fields that I don't want to be edited from that form (i.e. all of the fields that were there before I added the new check boxes). The new check box fields are not locked.

Here's the problem: When I open the form, it won't allow me to edit the new fields either. But if I switch the form to "Design View", and then switch it right back to normal view, it works properly! Why should that happen? If I then close the form and open it back up, I have to do the same thing again: switch to Design View and back again. Does this make any sense to anyone? Other forms that have always allowed editing are still working fine.
Feb 4 '08 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,597
I have a form which, when originally created, was solely for the purpose of viewing an order, not editing it (there was a different form for that), so the Allow Edits property was set to "No". But today I added a few new fields (mostly check boxes) to the table, and to the form as a tool to track the progress on an order. Since I wanted those new check box fields to be easy to use, I put them on the View Orders form instead of the Edit Orders (View Orders is the most commonly used form). I changed the form's Allow Edits property to "Yes". Allow Additions is still set to "No." Then I individually locked each of the fields that I don't want to be edited from that form (i.e. all of the fields that were there before I added the new check boxes). The new check box fields are not locked.

Here's the problem: When I open the form, it won't allow me to edit the new fields either. But if I switch the form to "Design View", and then switch it right back to normal view, it works properly! Why should that happen? If I then close the form and open it back up, I have to do the same thing again: switch to Design View and back again. Does this make any sense to anyone? Other forms that have always allowed editing are still working fine.
Try explicitly setting the DataMode Argument of the OpenForm Method to acFormPropertySettings. Of course if you do not state a DataMode Argument, it will be acFormPropertySettings by Default.
Feb 4 '08 #2

tdw
100+
P: 206
tdw
Try explicitly setting the DataMode Argument of the OpenForm Method to acFormPropertySettings. Of course if you do not state a DataMode Argument, it will be acFormPropertySettings by Default.
Yep, thanks a lot. I wasn't thinking about the fact that the forms were being opened by a Macro, which had them set to open in READ mode. It's working now.
I know that's not exactly what you said, but your suggestion is what made me realize that.
Feb 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.