From: Ray C on
Hi Ken
Thanks for your advice.and help anyway.

Regards Ray C

"KenSheridan via AccessMonster.com" wrote:

> 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
>
> .
>