Strings in expressions

[PhillipsAndrew]

I'm trying to requery an underlying form using the form name passed by OpenArgs. There's no problem getting the form name, my problem is how can I use this string in the expression to requery the underlying list when I delete records?

Example:

strCallingForm = [Forms]![MEC Approval].OpenArgs 'works fine

I then want to do:-
Forms![MEC Approval List]![FullList].Requery

but replace 'MEC Approval List' with the string for the calling form...
I tried..
Forms(strCallingForm)![FullList].Requery

and loads of variations of syntax, but each time I get an error.

This form is called from several places so using OpenArg seems like a elegant solution.

Any help on the syntax much appreciated

P

 

[Mile-O]

Try:

Forms("[" & strCallingForm & "]")![FullList].Requery

 

[PhillipsAndrew]

genius!! Thanks

 

[Mile-O]

And that's why we don't put spaces in field names, object names, etc.

Simple little errors like that. Because your form name has spaces within it we have to enclose it within Square Brackets.