This expression is typed incorrectly..trying to open form

[kndavies]

Hi
I have a form with tab controls and 6 subforms (1 per tab). This is a development from an earlier version of this app in which this form has 5 tabs/subforms and has been working happily for some months.

Opening the form from the switchboard opens it, but does not load the subforms. Double clicking it from the database window immediately gives "This expression is typed incorrectly or is too complex to be evaluated" 6 times (once per subform presumably). I have not added any expressions to the database. I have put break points at the start of every routine on the main form and subform but the error occurs before any of them are invoked.

This error occurs in both XP and 2000

Any advice as to tracking this down will be very gratefully received!!

Ken.

 

[KenReay]

hi

have compiled and fixed any errors reported?

try running the queries on which the sub forms are based, indepndantly to be sure they have no syntax errors

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[kndavies]

Hi Ken,

yes, I have compiled the code and the subforms aren't query based - they track documents through a long approval process and are all from the same table. I have thrown away my work and rebuilt it again and still get the same issue, even commenting out what little extra code I have added makes no difference.

Don't you hate it when those 1 day jobs stretch on, and on, and on?

Ken