Referencing a Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Referencing a Subform

Chuck Corvec

17 days ago

I know you have several videos on this. I have watched them all and I still have an issue. I am trying to requery a subform from a popup form. I have it working in most places but this one is giving me grief. Here is an example of the code that works...

Forms!Client_frm!CLientSUpport_sfrm.Form.Recordset.Requery
This is run from a Popup form and works great. I was able to replicate that on several areas of my database.

But this one does not work
Forms!Client_frm!CientInquiry_sfrm.Form.Recordset.Requery
It does not recognize CientInquiry_sfrm
That is the name of the form. I am guessing that the form name is not what it pulls from when validating the request.

I have search high, low and everything n between for another 'name' it could be referencing

	Kevin Robertson @Reply 17 days ago
Check the name of the Subform object (the control).

Chuck Corvec OP @Reply

17 days ago

OMG, thank you. I have been looking at this for hours and now it works. I have one other quirk with this reference thing
On my original example that works it does something weird

Forms!Client_frm!CLientSUpport_sfrm.Form.Recordset.Requery

Notice the upercase L and U

If I change it it will immediately put it back
I though your suggestion might be the same here too. So such luck
I checked everything including the name.

All are correct without those uppercase letters
I do recall that somewheree it was spelled like that but I changed it. Any wisdom on this

	Darrin Harris @Reply 17 days ago
Hi Chuck The CLientSupport_sfrm is that supposed to be ClientSupports_frm < _sfrm? also if you want to change case in VBA editor you can use Dim Dim ClientSupports Then just remove Dim after the case correction Example Dim MiD S = MiD(S,1) Remove the Dim if you like MiD Dim Mid will change it back Just don't forget to remove the Dim when your done

	Chuck Corvec OP @Reply 16 days ago
Darrin Hi Darrin It is supposed to be ClientSupport_sfrm The sfrm is for subform I am not trying to 'change' it per say. I am trying to find out where vba is pulling it form. I have check everywhere I can think of and can only see it spelled the correct way. I know it is not a big deal cause everything works, but it just bugs me. Thanks

	Donald Blackwell @Reply 16 days ago
If it's something that's really causing an itch, you could always try Save As Text. To save all your objects as text files, then have access read through them doing a binary compare which would not only check for spelling but capitalization.

	Chuck Corvec OP @Reply 15 days ago
Donald Thanks for the tip. I have never done that before. Unfortunately I still did not find where it is getting that from. I guess I'll just leave well enough alone Thanks

	Matt Hall @Reply 15 days ago
Check if the subform control inside Client_frm, not the actual form attached to it, is correctly named. If it is, you might rename that control to something completely different, save the form, and compact and repair the database. Then open the form, change the name back, and save the form. Try changing the reference back. That seems to fix it on my machine.

	Chuck Corvec OP @Reply 12 days ago
Matt I will try that Thank you

Next Unseen

New Feature: Comment Live View