Subform issue - not refreshing. (1 Viewer)

A

andy1968

Registered User.

Local time

Today, 02:07

Joined

May 9, 2018

Messages

131

• Jun 27, 2019

• #1

I have a form with 3 subforms that are linked by the one key field.


The subfroms are located on a tabControl


I open the main from from another form with a where clause.


Only one of the 3 subforms displays the related data. The others are empty.



If I change the view of the form to design view, and then reopen it, the subforms populate just fine. Moving to a new record and back does not have this same effect.


I have tried:


Me.subfromname.Requery from the on form load event without success.


I also tried Refresh - no luck

 

theDBguy

I’m here to help

Staff member

Local time

Today, 02:07

Joined

Oct 29, 2018

Messages

21,454

• Jun 27, 2019

• #2

Hi. We may have to see if first hand to be able to say why.

 

A

andy1968

Registered User.

Local time

Today, 02:07

Joined

May 9, 2018

Messages

131

• Jun 27, 2019

• #3

I'll send you something ASAP

 

A

andy1968

Registered User.

Local time

Today, 02:07

Joined

May 9, 2018

Messages

131

• Jun 27, 2019

• #4

Well, shoot.


When I exported the offending forms to a new database, it worked just fine.


I'm at a lose.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 02:07

Joined

Oct 29, 2018

Messages

21,454

• Jun 27, 2019

• #5

andy1968 said:

Well, shoot.

When I exported the offending forms to a new database, it worked just fine.

I'm at a lose.

Click to expand...

Try comparing the two to see if you can find any difference. If not, try re-importing the working copy back into the original file.

 

A

andy1968

Registered User.

Local time

Today, 02:07

Joined

May 9, 2018

Messages

131

• Jun 27, 2019

• #6

Imported it back to the original database and it did not work.


I'm attaching the sub database.

 

Attachments

• Database8.zip

  608.5 KB · Views: 58

A

andy1968

Registered User.

Local time

Today, 02:07

Joined

May 9, 2018

Messages

131

• Jun 27, 2019

• #7

Ok - the issue has to do with me having the filter on load for the subforms set to yes.


Turned it off and all is well.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 02:07

Joined

Oct 29, 2018

Messages

21,454

• Jun 27, 2019

• #8

andy1968 said:

Ok - the issue has to do with me having the filter on load for the subforms set to yes.

Turned it off and all is well.

Click to expand...

Hi. Glad to hear you got it sorted out. Good luck with your project.