A read only bound form has this button to create a New Record (autonumber: [CPID]), then open it with a New Form for Editing. Works great, except it fills with random data, unrelated to the index key or the bound [Patient ID #].
Do I need a Refresh, Requery or Repaint, or whatever? My assumption was that the rst.Update would get filed before the new form fetched the data.
Here is the CODE snippet:
Private Sub cmdCareNew_Click()
On Error GoTo Err_cmdCareNew_Click
Dim dbs As Database, rst As Recordset, newCPID As Long
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblCareData", dbOpenDynaset)