Log in

View Full Version : Custom form not sending values



slimbwoy
10-07-2015, 10:34 AM
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?

SamT
10-07-2015, 04:02 PM
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.

slimbwoy
10-08-2015, 05:22 AM
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.