Parameter Pop Up Windeows

[Melissa]

How do I get a Parameter query pop up window to go away when I open my form?
I can not find where I went wrong designing the form. Thanks! Melissa

 

[Jerry Whittle]

First run the query that is the record source for the form by itself. See if
the problem with the query.

If the query is OK, then you possibly have a text box control bound to a
field in the query that isn't there. After clicking off the pop up, do you
see any fields on the form that look 'wrong' such as blank or having #Name or
#Error in them?

 

[Melissa]

No, there are no empty/error boxes and my query is fine. The pop up comes
when I open my MAIN table form. It is for a yes/no box item. I am just so
stumped on this one.

 

[KARL DEWEY]

One way is to click on menu TOOLS - Analyze - Documentor. Select the form
and any query used as source for the form, listbox, or combobox. Click
options, select SQL, Parameters, and names. Click OK and OK. Click on the
icon toolbar to analyze with Word. Search for the popup text.

 

[Melissa]

Okay, i did everything you said but how do I know when there is pop up text
in the document I am looking at? How do I change it when I find it?

 

[KARL DEWEY]

how do I know when there is pop up text in the document I am looking at?
My post ended with -- Search for the popup text.
Are do you not know how to search a Word document?
You have to decide it it is in the form or query. Then in what part of the
item, etc.

 

[Tom Wickerath]

Hi Melissa,

To recap so far, your form uses a query as it's recordset, and the query
runs fine, without producing the parameter prompt. Is this correct?

I've had success in the past using the method Karl Dewey mentioned, although
I wouldn't limit the database documentation to just the form and the
query--I'd simply document the entire database. Don't close the resulting
report until you have first exported it as a rich text file. Then search the
resulting document for the exact text that you are seeing in the prompt. You
could have an error in a macro, or in VBA code, that is tied to an event on
your form. It doesn't take that much extra time to just run the documentor on
the entire database, with everything selected.

An alternate method that I've used in particularly tricky cases is to start
by making a copy of the form. Then delete one control at a time, testing the
form each time. If there are lots of controls on your form, then use the
lasso technique in form design view to delete small groups of controls,
testing the form each time you delete a group of controls. If you find that
the problem goes away after deleting a particular group of controls, then
start over with a fresh copy of your form, repeating this test by deleting
one control at a time from the indicated group of controls.

Does the form include a subform? If so, try:
1.) Opening the subform by itself. Does it open without an error?
2.) Removing the subform from form design view of the parent form. If the
problem disappears after the second step, then you likely have an invalid
Link Master Field or Link Child Field.

Does the form include a class module (ie. is the Has Module property set to
Yes)? If so, try setting this property to No, and save the form, to delete
all VBA code behind the form. Does the error still occur after doing this?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________