Problems updating a form (1 Viewer)

[gico1972]

Need some help with a form that i have created.

On my main menu[Form] i have a couple embedded forms that return information pertaining to outstanding balances to collected.

On clicking a hyper-link button from the same main menu i can access the query and add that the balance has been collected. Once i close the query i expect that the updated form no longer shows that record now that the balance has been taken however it still shows.

If i close the DC and re-open it doesn't show, so i know its a refresh issue however not sure how i taken this being a relative novice.

Any help would be most appreciated.

Thanks

 

[Trevor G]

You need a requery behind the after update event

me.subFormName.requery

 

[gico1972]

Tried this to but still no luck.

So that you understand correctly i have a main menu form with a unbound form on it which returns information from an underlying query.

The user can from the main form open a query and make an adjustment however the changes are not reflected on the form when the query is changed.

Not sure how better to explain however appreciate any help.

Regards

 

[Trevor G]

OK can you upload a sample of the database, if the requery hasn't worked it maybe that the Master/Child links have to be reset to the subform.

 

[missinglinq]

ISLALMSLA post reported as SPAM.