C
Crystal
I've got a module that access who's logged into a
database. Using ADO, it writes these records to
tblUsers. On the form:
1) the user selects a database from the openfile dialog
2) a delete query clears out the old records from tblUsers
3) the module is called to populate tblUsers
4) the subform (data source tblUsers) is requeried to
reflect all of the records in tblUsers.
Sometimes this works, most often it does not. The form
doesn't update and tests on the recordset show that BOF
and EOF are both true even though there are records in the
table.
What am I doing wrong?
Any suggestions?
Crystal
database. Using ADO, it writes these records to
tblUsers. On the form:
1) the user selects a database from the openfile dialog
2) a delete query clears out the old records from tblUsers
3) the module is called to populate tblUsers
4) the subform (data source tblUsers) is requeried to
reflect all of the records in tblUsers.
Sometimes this works, most often it does not. The form
doesn't update and tests on the recordset show that BOF
and EOF are both true even though there are records in the
table.
What am I doing wrong?
Any suggestions?
Crystal