Search results

Re: VBA - my recordset isn't filling up - clarification I have a form frmAssignments, and it appears in frmEvents as a subform. I think the problem is that after i opened frmAssignments as hidden in order for the program to run, VB is now working with the frmAssignments as an individual form...

I'm trying to fill up a recordset with the following values: Set rs = CurrentDb.OpenRecordset ("SELECT assignInCharge, workerEmail from tblAssignments, tblWorkers WHERE assignInCharge = workerNum and assignSend = -1 and assignIsSent = 0 and assignNum = " & strAssignNum) I checked with "If...