Reference recordset of different form

[tylerg11]

Hello,



I am using the following code to refer to a control on a different form.

Forms![FormName]![FormField]

However, I found that unless that field exists as a control on that form this won't work.

How do I reference a field on a different form if that field doesn't necessarily exists as a control on the form but only as a field in the recordset of the form.

[rpeare]

if you're using it as a reference in VBA script you can test to see if the other form is open, if it is, use the reference as you have it, if it's not use the reference from the form you currently have open.

here's an example of finding out if a form is open:

http://custom-designed-databases.com...xist-function/

yours would likely be easier because you just want to check one form.

[tylerg11]

I know the form is open. And I know the field I am trying to reference exists in its recordset. I'm just trying to figure out the syntax that allows me to reference it.

[rpeare]

oh I misread your original post. You're saying a FIELD exists in the recordset of the form but it may not exist in the actual display of your form. If that's the case you would have to recreate the data source in your code exactly as it is in the form that contains your data or put the field into your form and make it's visible property false, then you can reference it the way you have it but your users will not see it when they open the form itself.