Almost got it. Just need help with the refresh

[rkhondas2000]

Seems my access form is working as planned. Only issue I have is when i added a refresh button to clear the users answers incase they wanted to enter another date, the information on the main form stays there while the information on the sub form clears out. Is there a way to clear both at the same time? I tried adding the refresh on both the main form and sub form and it seems to only affect the sub form.

Thanks

 

[Micron]

I'm assuming you've correctly set up the child/parent relationship(s) between your sub and main and that the forms are based on queries. Once you have cleared the necessary controls, you must requery the main form, not refresh.

 

[Micron]

To all: this is another thread for the same thing.