Can anyone tell me why this isn't working?
From frmMenu the user clicks button Generate Report. In code I want to read the value of field vendor_id from table tblVendorID and put it into variable strID. I want to use this variable to open report rptApprovals. This report's record source is...
Can I use the For Each statement for each record in a table? If so, can you help me with the format of the statement?
For Each record In Table!tblVendorID
statements
Next
???
Strugling with VBA
Lisa