Hi all,
I've got a continuous form where I'm setting the record source on form load. This has been causing me some issues all day. I have a SELECT CASE based on what the user has chosen. The first case, written the same way, works fine. The second case, below, shows the right number of records, but only displays the data from the first record.
Any ideas???
Code:
strSQL = "SELECT tblExcelImportPositionNumbersTEMP.Field1, tblExcelImportPositionNumbersTEMP.Field2 FROM tblExcelImportPositionNumbersTEMP;"
Me.RecordSource = strSQL
txtField1 = Me!Field1
txtField2 = Me!Field2