Is there anything wrong with this line?

[Ling]

'Me.frmSubformMisc.Form!txtRawSheetsMisc = 1'

frmSubformMisc = subform
txtRawSheetsMisc = control name

This line is found in my visual basic but apparently there
is some errors.

Any ideas?
Thanx

Ling

 

[Allen Browne]

1. Open the main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. Check the Name property.

It may be that the name of the control is different from the name of the
form it holds (its SourceObject).

If that does not solve the issue, open the form in Form view.
Press Ctrl+G to open the immediate window.
Then query down the line until you find the problem, e.g.:

? Forms!NameOfMainFormHere!frmSubformMisc.Name

? Forms("NameOfMainFormHere")!frmSubformMisc.Form!txtRawSheetsMisc