Continuous Subform Requery - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Continuous Subform Requery

Monica Jones

2 years ago

I have a continuous form with a list of locations in a given area and a continuous subform for a list of the managers for each of the given locations. Where I run into an issue is that when I add a new location, the manager of the location in the record above appears in the subform of the new location. My concern is that this will confuse my users.

For example, if I have location 1701-D with manager Picard and start entering new location DS9 my subform will display Picard until that record is no longer dirty, then it's blank and I can add Sisko no problem.

I have Forms!MainForm!SubForm.Requery in the OnChange event for the location field but it doesn't help. I'm thinking it's something to do with the way my SubForm is grabbing the zone and district (zones are broken into districts) by defaulting to data from the MainForm. My research says I might need my SubForm CONTROL name, not just the regular name, but I've no idea how to find that.

TIA,
Monica

	Gary Orros @Reply 17 months ago
How are you adding a new user? If direct to the continues form, might be easier to make a “new location” form which can requery on close so the other forms can update or give you a combo box to add the manager.

	Monica Jones OP @Reply 17 months ago
In a continuous subform. I'll keep this in mind. What I've noticed over the past two weeks is that sometimes it displays the previous entry and sometimes not. I'm wondering if maybe there is some kind of corruption to some of my forms? The ones I've been using the most lately were from scratch, not copied from similar, older forms.

	Gary Orros @Reply 17 months ago
On my system with subforms I had issues with the records updating, so I’ve made individual subforms per parent form and then a simple form just to update the subform data. Then used the “on close event” to requery the subform. Thus works a ready for me and also allows me to choose who update and who can’t.

	Richard Vaneveld @Reply 17 months ago
Monica, Try "Forms![MainForm]![SubformControlName].Form.Requery".

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View