Selection criteria

[elizabeth]

I had this question emailed to me based on a FAQ. I never email responses as I don't want to give out my email address, so I'm posting it here. Hope you see it, Symm!

"I am using the same method as the FAQ entitled "Get selection criteria from a form".
and it worked fine... until i used that form as a SubForm. The Form works on it's own fine but when called through a SubForm, it can't locate the value in "[forms]![Form1]![cboFieldB]". It keeps puting up a dialogue box asking the user to input the value. Do you know why or how to get around it? Thanks, Symm"

I am no longer active as a developer, and haven't really used Access much in almost a year, so this is based on memory not testing. I believe when you use a subform you have to include both the name of the parent form and the name of the subform in the reference, such as "[forms]![frmParentName]![frmSubformName]![cboFieldB]"
HTH

 

[vickvickvi]

Hello, I will do my best to explain. The input box that you see that pops up is asking for a value and it is looking for a value in the Child form(Subform). Your script is not correct so it can not find the value. The correct script is forms![parentform]![subformName].form![Field Name in subform].

Have fun
DMV