Combo Box event based on selection

[tobydobo]

left the attachment off the previous message.

[tobydobo]

any ideas June?

[June7]

Might give the memo datatype a try. Otherwise, concatenate multiple textboxes into the body.

.HTMLBody = Me.Text63 & Me.Text65 & Me.Text67 & Me.Combo71 & Me.Mess_Text

The issue with this could be run-on text (lack of spaces). Might need:

.HTMLBody = Me.Text63 & " " & Me.Text65 & " " & Me.Text67 & " " & Me.Combo71 & " " & Me.Mess_Text

[tobydobo]

Hello again,

I now have the need to do what the title of this thread indicates again. It just so happens when I initially posted I found a better solution to accomplish what I needed done. However, now I want to make a button appear based on a selection from a combo box. Here is the code Im currently using for the Afterupdate event:

Private Sub Combo55_AfterUpdate()
If Me.Combo55 = "Brandon, MB" Or Me.Combo55 = "Linwood, MB" Then
Me.Command105.Visible = True
Else
'nothing
End If
End Sub

I do not get any errors with this code but it doesnt do anything at all. My combo works just the same. Im trying to make a button apear to the side of the combo box only when the conditions above are true. I have set the "visible" properties to "no" as the default value. Any other ideas?

[June7]

What is the RowSource of the combobox? Is it a multi-column? Show the SQL statement.

[tobydobo]

Yes and I thought right after posting that that may be the issue.

Is this what you needed? SELECT Dispatch.ID, Dispatch.Site, Dispatch.To, Dispatch.CC, Dispatch.Address FROM Dispatch ORDER BY Dispatch.[Site];

item in bold is the only column used in the drop down.

[June7]

So this combobox is set up as multi-column?
Property settings of?
NumberColumns: 5
BoundColumn: 1
ColumnWidths: 0";1";0";0";0"

If so, then the actual value of the combobox is the ID, not Site. Use the ID as criteria in the code. What would be the ID for "Brandon, MB" or "Lindon, MB"?

[tobydobo]

Once again you have SOLVED my issue. Thanks soooo much June7!!

[tobydobo]

One last thing....

Although the button appears now when certain selections are selected from the drop down, it doesnt dissappear when I select another selection. Is there something else I need to add to the if/else statement?

[June7]

Yes, try instead of 'nothing, put Me.Command105.Visible = False

[tobydobo]

duh...thanks again. : )

[tobydobo]

One more question on this form I created. Im looking to make certain fields 'mandatory' to where if you try to submit the form or click off the form, it will notify you of the requirement. Seems to be associated with a 'lostfocus' event but im not sure on the coding.

[June7]

You can set the field as Required in the table. Access will nag the user to provide data.

Can put code in some event to check the value of those fields. What do you mean by 'submit', a command button? In these situations I will disable the X close button so users can only close the form with my custom button. I will often but code to check the fields behind this button.

[tobydobo]

This particular form is the form you assisted me with in this thread. Its an email template form....the submit button is the Send button actually. The fields I need to make required are unbound fields as it is only used for user input into which is then inserted in to the email that is generated.

[June7]

Then put code in the Send button, like:

If IsNull(textbox1) Or IsNull(textbox2) Or ... Then
MsgBox "Must enter values in 1, 2, ..."
Else
'send email
End If