linked subform data does not change when master is changed

[jnmunsey]

I have master and sub forms whose data is from the same table but the forms each get their data from queries that separate the data. Essentially the subform data has the same fields as the main form data. Separating each into separate tables is a difficult option at the moment - too many other forms/reports to modify.

The main form gets its data from a query that pulls all data where "revision = 'main'" - The sub gets its data from a query "revision <> 'main'"

There is a field called "status" in each record that is linked(in addition to the id number) so all main records/revisions entered/modified should always have the same status value.

When I enter a new record and then add new revsions, the status on the revisions matches up fine with the main, but when I CHANGE the main record's status the existing revisions for that record do not get their status' changed, and as a result they no longer show up after the main is changed(since the status is linked)

I'm confused why this doesn't work - I had it working before but now it is failing - help.

Can anyone shed some light on this issue?

Thanks

John M

 

[rich.barry]

I don't totally understand what you're describing, but would suggest that if the sub forms are query based, the query result being dependant on the data in the main form, then the sub forms will have to be re-queried after a change to the main.

Probabily the way to go will be the After_Update event on the Main form triggering the code Forms!frmMain!frmSub.Requery

Richard