1 105ben Registered User. Local time Today, 16:29 Joined Feb 2, 2013 Messages 42 Feb 7, 2013 #1 Hello, Can anyone tell me why this code won't work? Me."Search for a fault using Fault ID subform 2".Requery Search for a fault using Fault ID subform 2 is the name of the subform
Hello, Can anyone tell me why this code won't work? Me."Search for a fault using Fault ID subform 2".Requery Search for a fault using Fault ID subform 2 is the name of the subform
A Artair Registered User. Local time Today, 16:29 Joined Jan 12, 2013 Messages 11 Feb 7, 2013 #2 Try Code: Me.[Search for a fault using Fault ID subform 2].Requery Although I would suggest not putting spaces in control names, it makes coding much easier.
Try Code: Me.[Search for a fault using Fault ID subform 2].Requery Although I would suggest not putting spaces in control names, it makes coding much easier.
M mdlueck Sr. Application Developer Local time Today, 11:29 Joined Jun 23, 2011 Messages 2,649 Feb 7, 2013 #3 105ben said: Search for a fault using Fault ID subform 2 is the name of the subform Click to expand... That is the name of the actual Subform control on the parent form? Or do you have an actual Access Form named that? You need to specify the name of the subform control, not what ever form name the subform control happens to be displaying.
105ben said: Search for a fault using Fault ID subform 2 is the name of the subform Click to expand... That is the name of the actual Subform control on the parent form? Or do you have an actual Access Form named that? You need to specify the name of the subform control, not what ever form name the subform control happens to be displaying.
1 105ben Registered User. Local time Today, 16:29 Joined Feb 2, 2013 Messages 42 Feb 7, 2013 #4 the square brackets worked thanks! And I was also using the Form's name, rather than the subform's reference.... silly me!! Cheers guys, both helped!
the square brackets worked thanks! And I was also using the Form's name, rather than the subform's reference.... silly me!! Cheers guys, both helped!
M mdlueck Sr. Application Developer Local time Today, 11:29 Joined Jun 23, 2011 Messages 2,649 Feb 7, 2013 #5 You are most welcome, 105ben.
