Subform questions

[Kiwi-Wombat]

Can someone answer some simple questions for me please?

From the main form, what is the syntax to set the focus to a field in the subform?

How do I hide or make visible a field on the subform during the operation of a procedure on the main form?

Does every field on the subform have to be linked to the main form?

Can I test for a value in a field in the subform?

Does a NotInTheList test work on the subform?

 

[KenHigg]

From the main form, what is the syntax to set the focus to a field in the subform?

forms!frmMain!subfrmMain.form!mycntrl.setfocus

How do I hide or make visible a field on the subform during the operation of a procedure on the main form?

forms!frmMain!subfrmMain.form!mycntrl.visible = false

Does every field on the subform have to be linked to the main form?

No.

Can I test for a value in a field in the subform?

if forms!frmMain!subfrmMain.form!mytextbox = "Hello" then
msgbox "Value is true"
end if

Does a NotInTheList test work on the subform?

Do not know...

=======================================

???
kh

 

[Kiwi-Wombat]

Thanks for your help

I had "forms!frmMain!subfrmMain" but didn't have the critical ".form!"