TonC
07-15-2017, 03:08 PM
Hello,:banghead:
In my DB, is a form named “frmWareHouse”, in that form is a subform that has the name “subfrmWareHouse”.
When I look in the VBA editor, at my code then the editor sees the name of the subform with a capital first letter.
The editor says “SubfrmWharehouse” but my formname is just “subfrmWhareHouse”.
I looked for a solution to solve this problem, but cannot find it. Its creates al lot of error messages.
When I try to change de first capital letter, into a small letter, and I click in the procedure somewhere else, then
the first letter jumps automatically back to a capital letter.
Forms!frmWareHouse!SubfrmWhareHouse.requery (acces cannot find the form).
The correct code is off course
Forms!frmWareHouse!subfrmWhareHouse.requery
Any help would be gratefull,
Greetings,
TonC
In my DB, is a form named “frmWareHouse”, in that form is a subform that has the name “subfrmWareHouse”.
When I look in the VBA editor, at my code then the editor sees the name of the subform with a capital first letter.
The editor says “SubfrmWharehouse” but my formname is just “subfrmWhareHouse”.
I looked for a solution to solve this problem, but cannot find it. Its creates al lot of error messages.
When I try to change de first capital letter, into a small letter, and I click in the procedure somewhere else, then
the first letter jumps automatically back to a capital letter.
Forms!frmWareHouse!SubfrmWhareHouse.requery (acces cannot find the form).
The correct code is off course
Forms!frmWareHouse!subfrmWhareHouse.requery
Any help would be gratefull,
Greetings,
TonC