are there any records in the subforms that have a blank unique id? That may be your issue
Thanks Eileen --- In [email protected], "Linda Moon" <[EMAIL PROTECTED]> wrote: > > I have a form and 2 subforms connected by "UniqueID" a text field w/ > 12 spaces. They are set up for data entry. > > Sometimes, when the 'UniqueID" field is entered into the parent form, > I get the following message: > > "This expression is typed incorrectly, or it is too complex to be > evaluated. For example, a numeric expression may contain too many > complicated elements. Try simplifying the expression by assigning > parts of the expression to variables." > > If I click "OK", the first subform disapears. Then the message comes > up again. When I click "OK", the second subform disappears. > > The UniqueID info differs from 8 to 12 digits. This problem doesn't > happen every time, but I have not been able to determine what causes > the problem. > > I am working w/ Access 97. > > Any suggestions? > > Thanks in advance for your help. > > Linda > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
