How do I use a variable as a form name in a setfocus statement

[chrisbee]

Hi

I have several tables which hold the postcoades for different areas. Each Two Letter Prefix is a unique table.

I have a variable USEPOSTCODE which decides which table to use....but I want to perform the following:-

USEPOSTCODE="POSTCODEPO"
Forms!USEPOSTCODE!postcode.setfocus

How can I acheive this?

 

[oharab]

Try:
USEPOSTCODE="POSTCODEPO"
Forms(USEPOSTCODE)!postcode.setfocus


hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[chrisbee]

Thank you very much - excellent