I have a split database and the backend is staying in Access. I heard that in this enviroment, DAO is the faster method to load an unbound form? If so, is there a better process to load up a forms unbound field values then what I'm doing?
My goal is to enhance the current Continuouis Form that I provide to date. The field columns span across and off the page. Plus I need to record the changes and send the new update to a change log table. So I need a new form to edit all the fields in one form for the selected record, allow changes to be cancelled at any time (thus my fear to use a bound form), and when they press OK it saves the changes in the main table and sends the updated record to the change log table.
Is there a better way to do approach this?
Private Sub Form_Open(Cancel As Integer)Dim rs As DAO.RecordsetSet rs = CurrentDb.OpenRecordset("SELECT TblFileList.* FROM TblFileList WHERE TblFileList.FileIndexNo=1571")rs.MoveFirstDo Until rs.EOF Me.FileIndexNo = rs!FileIndexNo Me.FileCurrentDate = rs!FileCurrentDate Me.cboCat = rs!FileCatCode Me.cboFileName_ver = rs!FileName_ver Me.FileDocID = rs!FileDocID Me.txtTitleOnDoc = rs!FileDocTitle Me.txtLink = rs!FileLink Me.FileName_orginal = rs!FileName_orginal Me.FileRevisedby = rs!FileDocName_short Me.FileRelativeDate = rs!FileRelativeDate Me.FileFunction = rs!FileFunction Me.FileJob = rs!FileJob Me.FileDocCode = rs!FileDocCode Me.FileDocSubCode = rs!FileDocSubCode Me.FileDocSubMicroCode = rs!FileDocSubMicroCode Me.FilePUOID = rs!FilePUOIDFileErr:rs.MoveNextLooprs.CloseEnd Sub