It sounds like it's not the text box's expression that's the problem, but
something else. Without being able to do any hands-on debugging, however, I
can't hazard a guess as to what it might be.

Ken Sheridan
Stafford, England

Ray C wrote:
Hi Ken
Access bing Access, I was probably a little premature in my excitement at
getting the thing to work.
I now have a dialogue box that pops up as Access is first opening up and
prior to the first screen being displayed saying
"The exprexssion is typed incorrectly or is too complicated, For example, a
numeric expression may containtoo many complicated elemements. Try
simplifying the expression by assigning parts of the expression to variables."
If I OK that, the first forms opens up and the database seems to work OK
from there on in.
Incidentally, if I completely remove the "Text Boxes" and the Dlookup
formula that you suggest, I still get the error message on opening.
Could you throw any light on the reason for this?

Yipppppeeee !!! Great. Smashin. Fabulous. Magic our Mourice. Tha Reet Up our
Street kid.
[quoted text clipped - 57 lines]
Ken Sheridan
Stafford, England

--
Message posted via http://www.accessmonster.com