Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Operations (2k)

    In the On Click event procedure of the command button on Data Entry Form 2, open the other form with acFormReadOnly as DataMode argument to DoCmd.OpenForm:

    <code>DoCmd.OpenForm FormName:="Data Entry Form 1", DataMode:=acFormReadOnly</code>

  2. #2
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Operations (2k)

    Hi, I have a form that is used to enter data when its opened normally. However, I would like to use this same form as just a read-only viewer as well, because otherwise, the forms will crash the database due to the fact that both access the same table's data. I'd rather not have to make a whole other form just to view the same info.

    My setup is this:
    Switchboard
    ->Data entry form 1
    ->Data entry form 2
    --->Data entry form 1 (for viewing reference purposes only)

    is there a way to open the form as read-only on button click when opened from the 2nd data entry form? and make sure that it is not stuck in read-only when it is opened by the switchboard?

    Edit: To be more clear, I don't mean opening up a 2nd instance of the form, just change the priveledges the form allows the user when opened from inside of the other form.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Operations (2k)

    wow, that was really more simple than what i was thinking, i should have known to look there. thanks Hans!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •