append help

[Adam1970]

Hi


i have an append query that populates "PurchaseDetailT." based upon a check box.
i have a form with parent "PurchaseF" & child "PurchaseDetailF.
currently if i check all items it populates the 1st purchaseF. how can i create a new purchaseF ie the purchaseID autonumber when i append other items? presently it adds any new appended items to the only purchaseT item autonumber 1.

I hope the above makes sense

Thanks
Adam

[June7]

Not really. Provide code for analysis. If you want to attach db, follow instructions at bottom of my post.

Why do you need append query? Why not form/subform arrangement for data entry?

[Adam1970]

Not really. Provide code for analysis. If you want to attach db, follow instructions at bottom of my post.

Why do you need append query? Why not form/subform arrangement for data entry?

Hi
The user's would have already performed a lot of the data entry on the salesform.
The append query is to move it from the SalesDetailT to the PurchaseDetailT. To eliminate extra work & possible errors.
When I append I also open the PurchaseF containing the PurchaseDetailF. However this form contains all items I appended and all previous items.
I want the form to open with a new record and only the items I have just appended to be within the loaded subform.
Thanks
Adam

[June7]

Again, provide code for analysis by some means.

[Adam1970]

There isn't any code yet.
It is purely an append query of specific items from SalesDetailT to PurchaseDetailT
The issue is the PurchaseDetailT isn't populating with the PurchaseID autonumber from the PurchaseT. Because of this its is pulling all items in the PurchaseDetailT to the purchaseDetailF subform & not just the most recent appended items.
I currently only have 1 record in the PurchaseT.
Thanks
Adam

[June7]

You have a query. That is code.

Best you provide db.

[Adam1970]

below is the image of my query. i need to be able to pull the data returned on this query into the childform (PurchaseDetailF) of the open parentform (purchaseF). I have added the following to the purchaseID field on the purchaseDetailF =[Forms]![PurchaseF]![PurchaseID]

[June7]

And you want that query used as subform RecordSource? That won't really work because subform loads before main form. Why aren't you using Master/Child links of subform container control.

Doubt I can offer anything else without reviewing db.