system messages

[Miranda]

hi,

i'm getting some system mesages requiring input popping up when a form is
loaded....i'm not sure where they are coming from. they keep prompting me to
enter forms!....!projectName. i've checked all my queries relating to the
form to make sure they aren't causing the messages. and i can't find any
other reason for them. is there anyway to track where these messages are
coming from?

 

[Ken Snell [MVP]]

Likely one of the following things:

(1) the form's RecordSource is based on a query, and that query contains a
parameter that matches what you see in the message (parameter) box. Look to
be sure that you don't have that parameter in the query's design view. If
you don't see it there, while the query is in Design view, click on Query |
Parameters and see if it's listed in the parameters listed - delete it from
there if it is.

or

(2) the Row Source of a combo box or list box is using a query that contains
this parameter. Check them all just as noted above.

 

[Reggie]

One other thing to check if not found using Kens advice. If the recordsource for your form or
comboboxes are based on a query and that query is based on other queries, check them as well.