Update subform

Soegstad

Registered User.
Local time
Today, 08:15
Joined
Dec 3, 2003
Messages
53
Hi
I have a subform that's based on a query.
In the main form I have a field that's linked to the query as a condition.
My problem is that the subform doesn't update when I change the fileld in the main form.
Does anybody have a solution to this?
Thanks.
Mads
 
It seems like the subform only updates every time I open the form? Is there anyway around this?
 
I guess what I'm asking is if there's any possibility to run the query in the subform when I change data in a field in the main form?
 
You could requery the subform on the after update event on the control of the main form but this sounds more like a master/child link problem.

Check the links by clicking on the subform in design view of your main form. If these properties are blank then click the ... button at the side to set them up.

Cheers

Flyer
 

Users who are viewing this thread

Back
Top Bottom