I have a form that opens another form (frm2)based on three fields from (frm1). frm2 is based on a stored query and produces 1-5 records in a list. I want to add a field where I can input a value for one particular record. When I try to do this I get the same value for every record found on frm2. How can I make the value be particular to one record? This value is used only to recalculate a value on frm2 so it is not something I want saved in a table or query.

Thanks for any help.

You will have to put a field in the table. This will allow you to put your value against one record. Then when you close the form you will have to delete the information in that field. You could do this by using an update query, or using VB.

HTH

John