Presenting problem: First record entered in Subform stays synchronized with control in Main Form, while no other records do.
main form = frmEntry
controls in main form = Date, Audit Type, Shift
sub form (continuous form) = frmSubform
Link Master Fields = Date, Audit Type, Shift
Link Child Fields = Date, Audit Type, Shift
I have these links set up because I want them to be reflected on every record in the Subform w/o the user having to type it in every time. I also want the Subform to filter based on the Date, Audit Type, and Shift so that when a new Date, Audit Type, or Shift is chosen there will be no records displayed, only the option to make a new entry. This is when the problem starts to appear:
I make these control selections in the main form and everything goes according to plan.
Date = 9/10/2014
Audit Type = Daily
Shift = 1
Now when I select a new date I would like to enter new records that reflect these new choices (essentially is should start a clean slate):
Date = 9/11/2014
Audit Type = Daily
Shift = 1
Here's where things start to go downhill, the first record that was entered for 9/10/2014 gets carried over to this new Subform that should display zero records because nothing has been submitted with this date.
Here is my VBA code for the Main Form:
Private Sub Form_Current()
[frmSubform].Requery
End SubPrivate Sub Form_AfterUpdate()
[frmSubform].Requery
End Sub
Question: What should I change in order to have the first record not carry over?
Thanks! Any help is greatly appreciated!!