Unanswered: Requery or Refresh current form Using VBA
I have a form that has a number of child subforms attached to it.
All the subforms are based on queries.
If a user edits the form, and portions of the subforms, only by printing the active selection will all the forms update, and the screen refresh to show the changes.
One subform looks at invoices, if a new price is added there is a subform which sums the new price to the old. Only when the form prints does the whole lot update.
I have tried [Forms]![Works Card].Requery
but end up right at the start of the database.
If I try [Forms]![Works Card].Requery acSelection it crashes with can't find a feild number 1.
Is there a way to Requery or refresh a current selection or requery the query that the subforms are looking at. I have a Save button and was hoping to run the update from there.
Any suggestions would be appreciated.
Thanking in Advance
Think of a subform as an ordinary control on a form. I guess [Works Card] is the name of a subform. The syntax
tries to requery the form [Works Card], not the control [Works Card]