Results 1 to 2 of 2

Thread: need you input

  1. #1
    Join Date
    Sep 2005

    Unanswered: need you input


    I've got a DoCmd.OpenForm ''formname'' which call an activeX. The ActiveX is just a calendar picking date. Upon selecting the date and clicking OK I would like the program to format a text box. I then included in my code a if..then..else... statement which format the textbox.

    However once the form is opened the if..then..else statement is executed before the user has time to select the date and click OK.

    How can I get the program to wait for the input. In Java I believe you would have written wait().



  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    It is a parameter of the OpenForm method. It is about the fourth parameter. Set it to acDialog and the code will pause until the form is either closed or hidden. If you want to get data off the form that opens, just hide the form, and put code in the calling function to get the data off the form and have the calling form close the second form.

Posting Permissions

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