Referencing fields from a subform on a main form

[jgarnick]

I have a main form that references several fields from a subform.&nbsp;&nbsp;Out of 13 fields, I can get 8 fields to work, but 5 fields give me a #Name error.&nbsp;&nbsp;The field types for the ones that don't work are Yes/No, Number, and Text. Although of the 8 working fields, those data types exist also.&nbsp;&nbsp;The fields that do not work on the main form do display properly on the subform. I have checked and re-checked the name properties, have gone through the expression builder to make sure my syntax is correct, have copied and pasted a working field and changed the control source only, have checked the format property but NOTHING has worked!!!&nbsp;&nbsp;I have checked the table that the fields are in to see if there is some funky setting for them--nothing.&nbsp;&nbsp;I've tried deleting them and doing it again.&nbsp;&nbsp;There is something about these 5 fields that the main form doesn't like--anybody know what it could be??&nbsp;&nbsp;I am at my wits end!<br><br>Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[famousb]

i know this may sound stupid, but i spent two hours being dumb about it yesterday (trust me, i tried everything except the simplest thing) - did you remember the &quot;=&quot; sign before the formula for referencing?<br>i know this probably isn't the problem, so i'll try to figure something else out for you.<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[jgarnick]

Yes, I had the = sign--but actually I have since found out the problem and had not gotten a chance to get back to Tek-tips---it was a recordsource statement for the main form buried in a sub of a sub (I was not the original creator of it)--so problem solved!&nbsp;&nbsp;Thanks very much for your help anyways! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>