Access 2002 Form

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • michael.garcia2@aig.com
    #1

    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.

    Tags: None
    • Rick Brandt
      #2
      Re: Access 2002 Form

      michael.garcia2 @aig.com wrote:[color=blue]
      > 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.[/color]

      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


        Comment

        Previous template Next
        Working...