I have a continuous form and Record Source is an Append table. There is fields: rbID, cBoxPrint, txtTable.
Since append table is filled with 3 different table values rbID can be duplicated, but that is ok since that is just for printing. (its invisible for users)
With cBoxPrint they select what should be printed, and txtTable is the name of table where value came from.
What I need is, when the click cBoxPrint the specific table should be updated, its something like this:
CODE
Dim strSQL As String
Dim tblName As TableDef
tblName.Name = Me!txtTable.Value
strSQL = "UPDATE tblName SET cBoxPrint = True WHERE rbID = " & Me!rbID
DoCmd.RunSQL strSQL
Dim tblName As TableDef
tblName.Name = Me!txtTable.Value
strSQL = "UPDATE tblName SET cBoxPrint = True WHERE rbID = " & Me!rbID
DoCmd.RunSQL strSQL
Hope its possible.
Tnx in advance.
