Hi all,
I need to set the form record source and control control sources on form load as I'm using the same form to display different things. To keep things simple for now, I've got txtPayCentre on the form. this is my Form Load event:
Code:
strSQL = "SELECT PayCentre FROM tblExcelImportPayCentreTEMP"
Me.RecordSource = strSQL
Me.Requery
txtPayCentre.ControlSource = Me!PayCentre
The form is a continuous form and it recognizes that there are 11 entries in the table. The only problem is that txtPayCentre displays #Name? for each entry.
I've also tried making a DAO recordset and doing the above, but no dice.
Am I in the wrong event? Should I be in Form Open?
Thanks,
Scott