Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi,

    Scratching my Head over how to work around the "Lock-out" when a Message or Input box is awaiting input in a VBA Module. I'm using this for an error correction message for an access table. IE when a Message Box or Input box is open the user is unable to check elsewhere to verify the information shown as the boxes are locked until they receive input.

    Any help or thoughts on this one would be appreciated.

    graliv

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    You can't do this with a message box or input box, you will have to create your own modeless form that displays the information and gets the user input.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Was hoping there was a simple work around. But when is it ever simple!!

    ?So I Will have to display the form, populate the content then write the edited contents to the relevant entries in the table. Ho Humm.

    Thank-You.

Posting Permissions

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