i keep getting aa prompt box asking me to enter a parameter value

[MIkeD666]

The problem I have is this when i test a query in the datasheet preview they work no problem. But as soon as i put the query in to a form or a report. I get a prompt box asking me to enter a parameter value. If I click ok without entering any thing. It go to the report or from and work fine.

Example i have simple query that is just a stock list. Just list a few fields rather then all the full list of field of the table. No input needed, other than clicking on the preview report. WHAT am i missing or doing wrong.

 

[Gasman]

Wouldn't care to say what it is asking for and show the query code in code tags would you?

 

[arnelgp]

do you really have a parameter on your query? is it QBF?

 

[MIkeD666]

Wouldn't care to say what it is asking for and show the query code in code tags would you?

HI sorry am still learn, I forgot to add the code.. it's very simple
SELECT TblStock.StkName, TblStock.STkBrand, TblStock.Stkquantity, TblStock.stockID
FROM TblStock;

 

[mike60smart]

Hi Mike

You would not use the query as the Record Source for your Form

You should create a Form based on tblStock

 

[plog]

First, that query has no point--its doing nothing---just use the table itself instead of the query.

Second, what does the prompt say? Most likely you've misspelled a field name. You've prefixed every field with 'Stk' except stockID--should it be StkID?

 

[MIkeD666]

Thank for the information. yes the query has no real task other than to display the table on a form in a standard display ,making it easer for the user( who is a none it person) to view the table. my point was the is no reason I should be getting a prompt box, it's such a simple query. But I will check the point made above by Plog. Thank you all for your help...

 

[MIkeD666]

What what can I say Good night's sleep and back to work. on running a few test runs the problem seems to have fixed it self. the only change I have done was last thing last night ( before the pub) was to tide up the data, I had a few records that were blank, which I delete. which in normal working conditions should never appear. But just to be safe i'v added a error trap to stop it happening .