Consulting

Results 1 to 3 of 3

Thread: Custom form not sending values

  1. #1
    VBAX Newbie
    Joined
    Oct 2015
    Posts
    2
    Location

    Custom form not sending values

    Hello, I have a small project working on but I am a newbie. I used the outlook developer to create an appointment form with drop down list.
    I actually hid the first page and sort of recreated the appointment page because i wanted to add this drop down list. Everything works fine when I create my appointment it gets saved and the option I select from the list actually remains. Problem is when I send this form as a meeting invite to another user with the same form installed, the selected value in the drop list does not stay. I have created a new read layout because i assume that when the users opens the form it goes into compose mode. What Im I missing?

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Two options:
    If you only have the one ListBox Control, then use a non visible TextBox and load it with the ListBox selection, when you send the form set the ListBox to hidden and the TextBox to visible.

    If you use several ListBoxes and or ComboBoxes, create another UserForm with only TextBoxes, set their Values from the first UserForm and send the Second.

    another user with the same form installed,
    You really don't want to be sending UserForms to someone with the same UserForm on their computer.

    Personally, I would create a Sub Send_Invite that actually wrote the invitation using the UserForm's Controls Variables to "Fill in the Blanks" of the Email and did the actual Sending of same.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Newbie
    Joined
    Oct 2015
    Posts
    2
    Location
    Ok.. thank you. I added and hid the text box but now the receiver form doesn't open. I am sort of new to this.. Why isn't it a good idea to send the form to another user with the same form ? Also, I recreated the default appointment form and hid it all this in effort just to add one button.

Tags for this Thread

Posting Permissions

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