How do I enter and then propagate form field to its subform records (continuous form mode)
Posted on 2008-10-05
I have a form in which I want to be able to enter a PO# and then have that PO# Propagate into all records of a subform which is in continous form mode and is based on a query that has returned all the records that need the PO update.
I tried using the code example from an already posted response to another members question on how to do something like this. The code offered was:
Private Sub Form_Current()
If Me.NewRecord Then
Me.txtState = Form_frmMainFormNameHere!txtState
I changed Me.txtState to Me.strPO# and Form_frmMainFormNameHere'txtState to Form_frmEnterPO#"NewPO# but all I get is an error about Must be collection.