Subform stops requery

[DentTec]

I have a subform that 3 Master/Child links such as Client, PaidDate and CheckNumber. After the main form is updated, the cursor will focus on a field in the subform and this subform will show the unpaid invoices belong to the current Client if the 3 mentioned criterias are not met. It worked perfectly until I formatted my computer and reinstalled everything, now it does not work anymore except when those 3 criterias are met (it shows that Client, PaidDate and CheckNumber). What gives ?

 

[GinaWhipp]

What version of Access? Have you installed all the SP's?

 

[DentTec]

Gina: I have 2007, what is SP ?

 

[GinaWhipp]

SP = Updates from Micrsoft. Have you downloaded all the updates since formatting your machine (and reloading everything)?

 

[missinglinq]

In this sort of situation, you also have to think about References that had been loaded, at some time, in your previous installation but are missing from your new, current installation.

If you haven't done this before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Linq ;0)>