No. It is a required field.
--- In [email protected], "eileen1309" <[EMAIL PROTECTED]> wrote:
>
> 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" <moondance30@>
> 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/
