Same Code Different Results.

[Confused]

I have this same code that references some other subforms:

If Forms!frmMigrations![Frmtaskseditag subform].Form.Completed = -1 Then
Forms!frmMigrations![Frmtaskseditag subform].Form.[Completed Date] = Date

But for this form when I check the box completed, it says " ...database
can't find the field 'l' referenced to in your expression." It's the same
exact thing I'm using in other places throughout the DB.

How do I fix this?

 

[Gina Whipp]

Confused,

If you are referring to a control on a subform from the main form then
try...

Me!Subform.Form!ControlName

In your case that would be...

Me![Frmtaskseditag subform].Form!Completed = -1

and

Me![Frmtaskseditag subform].Form![Completed Date] = Date

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm