Query Results in Form

[millercj]

Is there a way to list query results in a form? One line per record. I want to list them (by name) each with a check box aside of them. When a command button is clicked it will send the email addresses of all of those who's check boxes are checked to an outlook email? How should I do this?

 

[Dennisk]

Use the form creation wizard to set up a continious form. This is a form with multiple rows.

Then edit the form to add a check box to the row.

Sending the email may be accomplished in two ways,
either use the After update event of the check box to determine the state (Y/N)

If Y then use the DoCmd.Sendobject command to start you email.
Sometimes this does not work and it may be better to create an outlook object within Access to manage the emails.

 

[hardhitter06]

I have this code for the email part, can someone show me how to validate the Y/N Check box named "EmailCB"? I only know how to code a few things.

Private Sub Command24_Click()
On Error GoTo Err_Command24_Click

Dim stDocName As String

stDocName = "frmVendorSearchEditCommodity"
' DoCmd.SendObject acReport, stDocName
DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, Me.VendorCompanyEmail, , , "", , True
Exit_Command24_Click:
Exit Sub


Err_Command24_Click:
MsgBox Err.Description
Resume Exit_Command65_Click

End Sub

Thank you

I figured out something better to do for this-Thanks tho!