how to get the results of a query into a subform

[ManuelLavesa]

Hello Vlad, attached is the zip of the database as you requested. I am trying to do the append query but is not adding a new record, it says that I have a Key violation error. I removed the table PurchaseOrderDetails, and still gives me error. Well I hope you can figure it out. Thanks for your help.

[Gicu]

I think you forgot to include the query you mentioned in your first post that calculates the amount of each part number by supplier that needs to be re-ordered. That is the starting point of this thread and one of the most important parts.

I have started to modify the sample you provided but it because of your relationships and the empty tables you provided it is a slow process. I still think that once you look at it you'll see where you need to go. The supplier combo was listing the name only but you needed the supplierid, have a look at how I changed it into a 2 column rowsource with the first one (supplierid) hidden by setting the width to 0.

Try to finish the second append yourself (and the rest of the stuff I mention there) and post back if get stuck.

Cheers,
Vlad

[ManuelLavesa]

Thank you Vlad, Things are looking in the right direction, but still I can not get the first Append query to work. When I do View, the query looks perfect, just what we want, then I run it and it gives me Key violation error and does not append the record to the table PurchaseOrders. This time I included the query that finds the parts that need to be reordered and tried to work on the form, subform and somehow I can not get the two to link... But still the first append query is the key to all this working. So thanks again for all your help.

[ManuelLavesa]

Hello Vlad, I found the error for the append query I just had to add the SatusID to the query and make it equals 1. And it works, now I am trying to find the Invoice number from the PurchaseOrder Table from the query that finds all the parts. Thank you for all your help, I never did a query without a table before... I guess I have to learn more sql.

[Gicu]

hi there. You should try to do a compact and repair on the file that has your tables
Have you looked at my query (qryAddNewPO)? I think it was working in the sample I've uploaded.
Cheers
Vlad

[ManuelLavesa]

Hello again. I got everything running and I have a last question for today, is there a way of getting rid of those annoying warnings each time we run the append query. Thank you..

[Gicu]

Use Docmd.Setwarnings false before the first one and reset them to true after the the last one (Docmd.Setwarnings True).

Cheers,
Vlad

[ManuelLavesa]

Is working like a charm... Thanks to all of you...