469,935 Members | 1,600 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

Access 2002 Form

I have a form in (Access 2002 File Format) that has 61 combined Text
boxes, Combo boxes, and List boxes... 11 of those fields are in the
Form Header, the rest are in the Detail area... I also have 43 Command
Buttons in the detail area, each with a "strtextval" code to a certain
text box... 10 of those Command Buttons are in the Form Footer area,
with a macro assigned to them to go from page to page....

I duplicated this form, so that I can have a Data Entry Form, and a
Non-Data Entry Form...

My problem exists in the Non-Data Entry Form... Once I open the form
and search for a RecNum and find it, it won't let me update
information. (i.e. Name, State, Phone Number, etc...) The only way I
can update this info is by choosing one of my Command Buttons. Once
the Cmd Bttn executes, I have to delete what the Cmd Bttn just did, in
order for me to go ahead and update any other info on this form.

On the Default Open Mode I've selected the Shared option, and on the
Default Record Locking I've selected the Edited Record option.

Do I have to many fields on one form?

I've created Forms similar to this one in Access97 with no problems...

Thanks for taking the time to read this... I appreciate your help..
Mike G.

Nov 13 '05 #1
1 1311
mi*************@aig.com wrote:
I have a form in (Access 2002 File Format) that has 61 combined Text
boxes, Combo boxes, and List boxes... 11 of those fields are in the
Form Header, the rest are in the Detail area... I also have 43 Command
Buttons in the detail area, each with a "strtextval" code to a certain
text box... 10 of those Command Buttons are in the Form Footer area,
with a macro assigned to them to go from page to page....

I duplicated this form, so that I can have a Data Entry Form, and a
Non-Data Entry Form...

My problem exists in the Non-Data Entry Form... Once I open the form
and search for a RecNum and find it, it won't let me update
information. (i.e. Name, State, Phone Number, etc...) The only way I
can update this info is by choosing one of my Command Buttons. Once
the Cmd Bttn executes, I have to delete what the Cmd Bttn just did, in
order for me to go ahead and update any other info on this form.

On the Default Open Mode I've selected the Shared option, and on the
Default Record Locking I've selected the Edited Record option.

Do I have to many fields on one form?

I've created Forms similar to this one in Access97 with no problems...

Thanks for taking the time to read this... I appreciate your help..
Mike G.


What command are you using to open the form? Sounds like you are opening it
ReadOnly. If one of your command buttons alters a value then the ReadOnly
option is overridden (for that record).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Peter Frost | last post: by
28 posts views Thread by Neil Ginsberg | last post: by
52 posts views Thread by Neil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.