Access 2002 Form

[michael.garcia2]

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.

[Rick Brandt]

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