Hello, I have a few questions about the open args statement and how to best implement it in a form. Currently, I have controls at the top of several forms (move forward and backwards) which keep the same [Call Number] field entered in each form. to do this, I used a code similar to:
Private Sub Command397_Click()
If Me.Dirty Then
On Error GoTo Command104_Click_Err
DoCmd.OpenForm "frmHealthOutcomeMortality", , , , , , Me.CallNumber
DoCmd.Close acForm, "frmHealthOutcomeFunctionQOL"
Private Sub Form_Current()
Me.CallNumber = Me.OpenArgs
For each of the controls. This works pretty well in my experience, but some of the users have been complaining about how the controls are working. Some mentioned that data might be overwritten or not recorded. The field [Call Number] is a pk for these forms/tables. Does anyone have suggestions on if this is a poor way to pass the record number from one form to another? What could be causing these issues?
Any comments are as always greatly appreciated and welcomed,