Access 2007 - Form control with VBA

[washington]

I have a form which includes a subform. I have previously used a button to open a subform of the subform and displayed the results on the form (ie not within the boundaries of the subform). The button wizard creates a link between the subform and subsubform and therfore it doesnt matter that there is no link between the form and subsubform.



I'd like to get rid of the button and use VBA and I've tried using the visable command but I cant work out how to generate the necessary links?

[rpeare]

what's the code behind your button?

Could you not just use that same code in one of the EVENT properites?

For instance let's say after you enter data in a specific field you want your second subform to open with code instead of your button (which already exists)

you could have

If not isnull(txtField) then
'Execute whatever you're executing with your button now
else
'do whatever else you normally do
endif