Results 1 to 8 of 8
  1. 08-05-2017, 06:52 PM #1
    ortizimo
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88

    Disabled boxes not saving...

    I have this code for my collection DB that when you select an option from a drop-down menu it checks the correct box needed and disables all other boxes. The issue is that if I move to other records or get out of the form and come back in, the options are no longer disabled...why? Here's the code I used...

    '---------------------------------------------------------------------------'
    'CHECKBOX SELECT USING CONSOLE DROP-DOWN MENU'
    '---------------------------------------------------------------------------'
    Private Sub ConsoleName_AfterUpdate()
    If Me.ConsoleName = "NES" Then
    Me.Cartridge = True
    Me.Cartridge.Enabled = True
    Me.Original30.Enabled = True
    Me.Disc = False
    Me.Disc.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False


    Me.OtherBox.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.ISO = False
    Me.ISO.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Else
    If Me.ConsoleName = "SNES" Then
    Me.Cartridge = True
    Me.Cartridge.Enabled = True
    Me.Disc = False
    Me.Disc.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.ISO = False
    Me.ISO.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "Genesis" Then
    Me.Cartridge = True
    Me.Cartridge.Enabled = True
    Me.SEGA32X.Enabled = True
    Me.SEGACD.Enabled = True
    Me.Disc = False
    Me.Disc.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.ISO = False
    Me.ISO.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "Gamecube" Then
    Me.Disc = True
    Me.Disc.Enabled = True
    Me.Cartridge = False
    Me.Cartridge.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.ISO = False
    Me.ISO.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "Playstation" Then
    Me.Disc = True
    Me.Disc.Enabled = True
    Me.Cartridge = False
    Me.Cartridge.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.ISO = False
    Me.ISO.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "Wii" Then
    Me.Disc = True
    Me.Disc.Enabled = True
    Me.ISO.Enabled = True
    Me.Cartridge = False
    Me.Cartridge.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "XBOX360" Then
    Me.Disc = True
    Me.Disc.Enabled = True
    Me.Cartridge = False
    Me.Cartridge.Enabled = False
    Me.HuCard = False
    Me.HuCard.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.CD_i = False
    Me.CD_i.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    Else
    If Me.ConsoleName = "TG16" Then
    Me.HuCard = True
    Me.CD_i.Enabled = True
    Me.Cartridge = False
    Me.Cartridge.Enabled = False
    Me.Disc = False
    Me.Disc.Enabled = False
    Me.OtherBox = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD = False
    Me.SEGACD.Enabled = False
    Me.WiiWare = False
    Me.WiiWare.Enabled = False
    Me.VirtualConsole = False
    Me.VirtualConsole.Enabled = False
    Me.Original30 = False
    Me.Original30.Enabled = False
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End Sub
    Reply With Quote Reply With Quote
  2. 08-05-2017, 07:37 PM #2
    Micron
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Enabled can only be set permanently in design view. If you want controls to be disabled based on some value, you'll have to pick the correct event(s) for this. If it is necessary to have this happen in more than one event, you certainly want to make it far simpler than what you have - which is quite doable. At the very least, it looks like simplification would involve a loop for setting all to disabled, then enabling the few you don't want disabled. It appears there's only a few enabled in any scenario. If you're going to construct a loop, then the option is to disable only the ones you want to, but base it on some commonality. For this, I use the control .Tag property and will look for those whose tag has the value I put there that makes sense for what I'm doing. Gotta say though, I only took a quick glance at the code because I really dislike reading code that's not within code tags. Small amounts are OK, but when there's that much, it's a real turn off for me.

    The events you'll likely need is Current for the form, AfterUpdate on some control that drives this (such as a checkbox or combo box) and the form Load event. If that's the case, I'd write a procedure and have it do its magic and just call it from each event. Then you only have to write it once.

    EDIT: hopefully you realize that with your construct, if none of the conditions are met, nothing happens, and as soon as one of them is true, the rest is not evaluated even if any of them are true.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.
    Reply With Quote Reply With Quote
  3. 08-05-2017, 09:33 PM #3
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Textboxes and comboboxes can utilize Conditional Formatting to be disabled based on some condition per record.

    Doing this in VBA will set the property for all instances of a control, so in Continuous or Datasheet view a control set as disabled will show as disabled for all records.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  4. 08-05-2017, 10:05 PM #4
    Micron
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Correct you are. Maybe I should have asked what type form rather than making my own conclusion based on the post and its code. Seems like there's about 30 check boxes so I presumed it to be a single form, not really being able to picture a continuous or datasheet form based solely on one combo and 30 ish check boxes. I guess we'll soon know.
    Reply With Quote Reply With Quote
  5. 08-05-2017, 10:17 PM #5
    ssanfu
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The posted code would be much cleaner if the "Select Case" construct was used......

    Something like might work:
    Code:
    '---------------------------------------------------------------------------'
'CHECKBOX SELECT USING CONSOLE DROP-DOWN MENU'
'---------------------------------------------------------------------------'
Private Sub ConsoleName_AfterUpdate()

    'first set controls disabled
    Me.Cartridge.Enabled = False
    Me.CD_i.Enabled = False
    Me.Disc.Enabled = False
    Me.HuCard.Enabled = False
    Me.ISO.Enabled = False
    Me.Original30.Enabled = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD.Enabled = False
    Me.VirtualConsole.Enabled = False
    Me.WiiWare.Enabled = False


    Select Case Me.ConsoleName
        Case "NES"
            Me.Cartridge.Enabled = True
            Me.Original30.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.SEGACD = False
            Me.SEGA32X = False
            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.SEGA32X.Enabled = False
        Case "SNES"
            Me.Cartridge.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.SEGACD = False
            Me.SEGA32X = False

            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.Original30.Enabled = False

        Case "Genesis"
            Me.Cartridge.Enabled = True
            Me.SEGA32X.Enabled = True
            Me.SEGACD.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False

        Case "Gamecube"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "Playstation"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "Wii"
            Me.Disc.Enabled = True
            Me.ISO.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "XBOX360"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "TG16"
            Me.CD_i.Enabled = True

            Me.HuCard = True
            Me.Cartridge = False
            Me.Disc = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.Disc.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
    End Select
End Sub

    Just sayin.....
    Reply With Quote Reply With Quote
  6. 08-05-2017, 11:06 PM #6
    davegri's Avatar
    davegri
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    Attachment 29823
    This will do the job, but it's pretty useless standing alone. We need a better description of the OP's requirements to make more informed suggestions.
    Reply With Quote Reply With Quote
  7. 08-06-2017, 07:14 AM #7
    ortizimo
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    After posting my question I saw somewhere else a similar code and tried it. it actually does the trick and looks better organized...thanks!

    Quote Originally Posted by ssanfu View Post
    The posted code would be much cleaner if the "Select Case" construct was used......

    Something like might work:
    Code:
    '---------------------------------------------------------------------------'
'CHECKBOX SELECT USING CONSOLE DROP-DOWN MENU'
'---------------------------------------------------------------------------'
Private Sub ConsoleName_AfterUpdate()

    'first set controls disabled
    Me.Cartridge.Enabled = False
    Me.CD_i.Enabled = False
    Me.Disc.Enabled = False
    Me.HuCard.Enabled = False
    Me.ISO.Enabled = False
    Me.Original30.Enabled = False
    Me.OtherBox.Enabled = False
    Me.SEGA32X.Enabled = False
    Me.SEGACD.Enabled = False
    Me.VirtualConsole.Enabled = False
    Me.WiiWare.Enabled = False


    Select Case Me.ConsoleName
        Case "NES"
            Me.Cartridge.Enabled = True
            Me.Original30.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.SEGACD = False
            Me.SEGA32X = False
            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.SEGA32X.Enabled = False
        Case "SNES"
            Me.Cartridge.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.SEGACD = False
            Me.SEGA32X = False

            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.Original30.Enabled = False

        Case "Genesis"
            Me.Cartridge.Enabled = True
            Me.SEGA32X.Enabled = True
            Me.SEGACD.Enabled = True

            Me.Cartridge = True
            Me.Disc = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Disc.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False

        Case "Gamecube"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "Playstation"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.ISO = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.ISO.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "Wii"
            Me.Disc.Enabled = True
            Me.ISO.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "XBOX360"
            Me.Disc.Enabled = True

            Me.Disc = True
            Me.Cartridge = False
            Me.HuCard = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.CD_i = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.HuCard.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.CD_i.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
        Case "TG16"
            Me.CD_i.Enabled = True

            Me.HuCard = True
            Me.Cartridge = False
            Me.Disc = False
            Me.OtherBox = False
            Me.SEGA32X = False
            Me.SEGACD = False
            Me.WiiWare = False
            Me.VirtualConsole = False
            Me.Original30 = False

            '            Me.Cartridge.Enabled = False
            '            Me.Disc.Enabled = False
            '            Me.OtherBox.Enabled = False
            '            Me.SEGA32X.Enabled = False
            '            Me.SEGACD.Enabled = False
            '            Me.WiiWare.Enabled = False
            '            Me.VirtualConsole.Enabled = False
            '            Me.Original30.Enabled = False
    End Select
End Sub

    Just sayin.....
    Reply With Quote Reply With Quote
  8. 08-06-2017, 07:21 AM #8
    Micron
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    I had written a much shorter version too but was waiting for an answer as to whether or not the form was single or not.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Saving record preserving entered data in text boxes without closing the form
    By WAVP375 in forum Access
    Replies: 1
    Last Post: 08-06-2016, 10:39 AM
  2. Check Boxes saving log in data?
    By Z1nkstar in forum Access
    Replies: 1
    Last Post: 03-20-2014, 01:29 PM
  3. Combo boxes and saving information based off the combo box selection
    By RoundTrip in forum Forms
    Replies: 6
    Last Post: 02-19-2014, 11:11 AM
  4. Saving Values from Combo Boxes in a Table
    By sidewinder2 in forum Forms
    Replies: 12
    Last Post: 07-11-2013, 12:47 PM
  5. ctrl F on Form with Enabled and Disabled bound boxes
    By sambeer in forum Forms
    Replies: 7
    Last Post: 11-20-2011, 08:34 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums