I am fairly new to Access 97, so excuse me if this question appears a little stupid.

I have created a form based on a query, but whenever I open the form it prompts me for three parameters relating to fields in my databases before allowing me into the form. There is not criteria attached to the query.

Why does this happen and how can I stop it?

Thanks in advance.

[This message has been edited by GingerMagician (edited 11-23-2000).]

If there is no criteria in your query, don't use a query, base your form on the table directly.

Hope that works

ian

Thanks for that Ian.

I am still slightly confused though, you say if there's no criteria don't use a query. The reason I used a query is because it was the only way obvious to me to have access to fields from more than one table within the form.

Am I missing something basic here?

Thanks again.

Your approach to showing data from more than one table is correct. Try this: Open your query in Design mode. Click on the Query menu. Select Parameters. If there are any parameters in the dialog box that opens up then delete them.

Other than that I have no other ideas....

HTH,
Jack

Sorry, I forgot that you had two tables.
As Homer would say DOH!!!