Is this the correct way to open a new form and transfer data from a dataview to the newly opened form for display?:
DoCmd.OpenForm "Worksheet", , , "Id = " & Me!ReconciliationID
[Worksheet].[txtStatementBalance] = Me.StatementBalance
End Sub
Is this the correct way to open a new form and transfer data from a dataview to the newly opened form for display?:
DoCmd.OpenForm "Worksheet", , , "Id = " & Me!ReconciliationID
[Worksheet].[txtStatementBalance] = Me.StatementBalance
End Sub
That should work.
However, saving calculated data (data dependent on other data), especially aggregate data, is usually a bad idea.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.