I just spent two hours trying to work out why my procedure wouldn't
allow me to set the focus to a control in a subform. The control is in
a tab control in the subform
My code looked like this
forms!mainform.form!subform.setfocus
forms!mainform.form!subform!control.setfocus
Simple enough I think you would agree.
Nothing I tried would work and now the boss is starting to look at me
funny.
Last resort, I copied the control to the clipboard deleted it and
exited the database. I re-opened the database and ran the procedure,
which it didn't like because now the control doesn't exist. I then
went to design mode and pasted the control back into the form saved it
and ran the procedure again.
Hey presto it now works!
Has anyone seen a problem like this?