Suzanne,
Yes, that exactly why it is changing. The field would have to *bound*,
thereby attaching it to a record to not update all the same fields in a
continuous form. I gather you are not wanting to *store* that DLookup
value. Please explain what you trying to accomplish and there might be a
solution that gets you what you want.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
"Suzanne" wrote in message
...
In Access 2007 I have a continuous form on which I have an unbound text
box
that defaults it's value using a dlookup, however, it's not working
properly.
It seems that the value is always defaulting to the first records value.
If
I manually change it - all records change. Is this because it is
"Unbound"?
I'm fairly new to Access so any advice would be appreciated.
Thanks!