I'm working with a form that contains date entries from queries built to
project future expiration dates.

I've modified the original table control source selection for the date.
(added a selection to the table that was not selected when the form was
created.) After closing the form the msg stated above appeared, though I
could still get into the form view on the day the change was made, but cannot
get into the form view to modify or look at the property tables of the form.

In design view, the control source for the affected text has no other
selectable items on the pull-down menu.

I'd like to take proper actions to correct the error msg, but don't know how
to complete the task.

Hold down the Shift key to preve4nt code from running when you open a custom form.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Syntax error in FROM clause" <Syntax error in FROM (E-Mail Removed)> wrote in message news:65C44444-9323-4D37-9B12-(E-Mail Removed)...
> I'm working with a form that contains date entries from queries built to
> project future expiration dates.
>
> I've modified the original table control source selection for the date.
> (added a selection to the table that was not selected when the form was
> created.) After closing the form the msg stated above appeared, though I
> could still get into the form view on the day the change was made, but cannot
> get into the form view to modify or look at the property tables of the form.
>
> In design view, the control source for the affected text has no other
> selectable items on the pull-down menu.
>
> I'd like to take proper actions to correct the error msg, but don't know how
> to complete the task.