#Name? Error... trying to link two fields in same form

I'm not sure if this is some random bug in the system, but I keep
getting the #Name? error on one of my forms when I try to link one
field to another. For example, I have one field called txtTrialField
which = date(). I then have a second field which =[txtTrialField]. For
reasons beyond me, it comes up with the above error. I'm actually
trying to make something a little more complicated but after an hour of
frustration, I reduced it down to this simple problem.

I swear it was working earlier in the day and the same arrangement
works on other forms. Does anyone have any idea why it would not work
on my current form??

Grrr :(

Cheers

Reg

re: #Name? Error... trying to link two fields in same form

What you are trying to do should work.

Try changing the Name of your text box. Access gets confused if it has the
same name as a field in the form's RecordSource, but it is bound to an
expression.

If that does not solve the problem, try unchecking the Name AutoCorrect
boxes under:
Tools | Options | General
Then compact the database.
Explanation of why:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Regnab" <p.heywood@gmail.com> wrote in message
news:1136263827.873130.102860@g44g2000cwa.googlegr oups.com...[color=blue]
> I'm not sure if this is some random bug in the system, but I keep
> getting the #Name? error on one of my forms when I try to link one
> field to another. For example, I have one field called txtTrialField
> which = date(). I then have a second field which =[txtTrialField]. For
> reasons beyond me, it comes up with the above error. I'm actually
> trying to make something a little more complicated but after an hour of
> frustration, I reduced it down to this simple problem.
>
> I swear it was working earlier in the day and the same arrangement
> works on other forms. Does anyone have any idea why it would not work
> on my current form??
>
> Grrr :(
>
> Cheers
>
> Reg[/color]

re: #Name? Error... trying to link two fields in same form

Thanks for your response Allen. Tried both things you suggested and it
still wouldn't work. It's hard to know for sure what the problem is -
I'm actually fixing up a database for a fella that didn't use naming
conventions etc so there could easily be some clashes that I'm not
aware of.

I ended up taking another copy of the original database and pasted my
text boxes with code into the same form in his other database and it
works fine. So while its certaintly not a pretty solution, it seems to
work.....

Thanks again - and I'll be happy to try other changes if you have any
other ideas because I would like to know what the glitch was.

Thanks again,

Reg

re: #Name? Error... trying to link two fields in same form

That's a fair enough solution.

Could have been a corruption. SaveAsText/LoadFromText could achieve the same
result, but your approach is as good as any.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Regnab" <p.heywood@gmail.com> wrote in message
news:1136268008.301651.325760@z14g2000cwz.googlegr oups.com...[color=blue]
> Thanks for your response Allen. Tried both things you suggested and it
> still wouldn't work. It's hard to know for sure what the problem is -
> I'm actually fixing up a database for a fella that didn't use naming
> conventions etc so there could easily be some clashes that I'm not
> aware of.
>
> I ended up taking another copy of the original database and pasted my
> text boxes with code into the same form in his other database and it
> works fine. So while its certaintly not a pretty solution, it seems to
> work.....
>
> Thanks again - and I'll be happy to try other changes if you have any
> other ideas because I would like to know what the glitch was.
>
> Thanks again,
>
> Reg[/color]