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

Access 2002 Form

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.