I have 2 subforms on a page. The first subform holds data from other sources-claims that have been submitted and paid. The 2nd subform shows all the claims that are currently in her database.
The user needs to move these finished claims to her database. She can look over the data, confirm it is a new/valid claim and put it in her database by clicking ADD
The ADD button - saves the current record then calls a macro. The macro calls a query that appends the record to her claims. It then requeries the first subform and removes it from consideration (it no longer shows in the 1st subform).
The one issue I have is how to requery the 2nd subform. This new claim does not show up on her finished claims form until she goes to a different record then back to the record.
Should I do this whole procedure from vb and not call a macro? Either way how do I make this 2nd form show this new claim.
Thanks.
.
The user needs to move these finished claims to her database. She can look over the data, confirm it is a new/valid claim and put it in her database by clicking ADD
The ADD button - saves the current record then calls a macro. The macro calls a query that appends the record to her claims. It then requeries the first subform and removes it from consideration (it no longer shows in the 1st subform).
The one issue I have is how to requery the 2nd subform. This new claim does not show up on her finished claims form until she goes to a different record then back to the record.
Should I do this whole procedure from vb and not call a macro? Either way how do I make this 2nd form show this new claim.
Thanks.
.