On Current event gives me error "can't find field '|' referred..."

[Kevin]

I have a subform named Equipment that has data with a one
to many relationship with data in another subform named
IPAddress. I have an OnCurrent event set in Equipment to
update the IPAddress information. When a requery event
happens I get this error "..can't find the field '|'
referred to in your expression." I checked all the
spelling, field names, and syntax and I do not know why
the pipe "|" symbol is used in this error. Please help!

 

[StCyrM]

Hi Kevin

I have a feeling that you are not referencing your subform properly.

The general expression would be as follows:

[forms]![myMainForm]![mySubForm].form!controlOnMySubform

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc.