User Input/Combo Box in Append Query

[Torq]

Hi,

I have a table(Unencodeable) which contains ProductID 's and Reason which new products are checked against.

I'm trying to use an append query to input new data to this table.
Adding the ProductID is easy, I'm just using a Parameter. What I need though is to limit the choice of the Reason field to one of five options.

To this end I've created a seperate table called Reasons with the five possible choices in.

Is it possible to have the parameter/input dialog box be a Combo box which limits the user's choices to the five, all within the Append query?

I realise I could have a seperate form where the user inputs the ProductID data and chooses the reason, and then clicks a submit button. But I was wondering if its possible to do it all within a query.

Thanks in advance,

Simon

 

[dcx693]

You cannot present pre-selected choices using a parameter query. The dialog box it present is a simple text box without any error checking or verification.

You might be able to jump through some hoops using a complicated IIF formula in your parameter query to solve your problem, but you really need to use a form to solve this problem.