Why did table data suddenly stop displaying in form?

[RuralGuy]

Put a TextBox on the MainForm bound to the SystemID field of the RecordSource and you will see what is happening.

[Jennifer F]

I added the text box. I guess I'm not recognizing what I need to see. Can you explain what's happening with that text box that could be causing the data not to show? When I tested the data again, it looks like when I open the [Systems] page, the SystemID textbox says (New) as if I'm going to add a new record, even when there are already 3 systems assigned to the site. When I try to use the [Jump to System] combo box to go to one of the existing systems, it tells me that I can't use the find/replace function. If I start to add a new system, then the system ID shows up, which is what I'd expect. What am I missing?

[RuralGuy]

Maybe I just don't know how to use your forms yet. The left hand SubForm will have no records until there is a valid SystemID in the new textbox on the MainForm. I expected there to be records in that SubForm when we got there.

[Jennifer F]

You start off on the Customers form. Click the "View Customer Sites" button to get to the first Site form. Then click the "View/Add Systems Details for this site" button on that form. When you're at the Systems form, choose a system from the [System] combo box, choose a [Frequency] and maybe put some test data in another field or two. Then tab or click down in the left-hand subform and choose a [Cycle Type] and put any date in the inspection date field. You can put another line of cycle type and inspection date in, just to get a couple of [Cycle] records in there. If you then press the "refresh" button that I've added to the page, the system that you just entered will show up on the right-hand subform, since you've not assigned that system to the site. It still looks like everything is OK. Now close the form, which will take you back to the [Site] form. Now click on the "View/Add Systems Details for this Site" button again. You're back at the Systems form, and all the systems that you added are listed on the right-hand subform, but none of the data appears on the main form. In addition, the "count" that I have listed above the navigation buttons will say "System 1 of 0 for this site" when I know there is at least one in existence because we just added it, and we can see it in the right-hand subform.

[RuralGuy]

I have to go to several meeting now but I'll check in later. I really cannot follow the logic of your forms yet, sorry.

[RuralGuy]

In the WhereCondition argument of the Sites Form
"View/Add Systems Details for this Site" button,
change: [Forms]![Sites].[SiteID]=[Forms]![Systems].[SiteID]
to: [SiteID]=[SiteID]
...and see if that now works as you want.

[RuralGuy]

Did that make any sense?