SQL statement in a form

[Ana]

Hi,

In a form I have a Combo1 field which provides Agent_Id and Agent_Name from
Table1.

Then I have Date_In and Date_Out fields which are chosen from a calendar.

I would like a command button to execute the following SQL statement:



UPDATE dbo.Table1
SET COMMISIONS_LIQ = '1'
WHERE (AGENT_ID = Combo1) AND (COMMISIONS_LIQ = 0) AND
(DATE_START BETWEEN Date_In AND Date_Out)



Howto?

TIA

Ana

 

[smk23]

Ana, are you asking how to execute SQL from within MS Access? If so try this:

Dim strSQL As String

strSQL = "UPDATE dbo.Table1" & _
" SET COMMISIONS_LIQ = '1' " & _
" WHERE (AGENT_ID = Combo1) AND (COMMISIONS_LIQ = 0) AND" & _
" (DATE_START BETWEEN Date_In AND Date_Out)"

DoCmd.RunSQL strSQL

HTH