Update table with new records using a form and subform

[riley23258]

Hello all,

Problem:
Trying to use a form and subform to track material receipts for a company.

Created a receiving form "frm_Receiving" (attached). This form also contains a subform "frm_IBReceipts" this shows the purchased materials and is bound to a table "tbl_PurchMats". This table is updated by another form "frm_PurcahseOrders". The general concept is the customer can use frm_PurchaseOrders to enter new orders, and the receiving associates can then view those material items using the form "frm_Receiving" with the subform "frm_IBReceipts".

The subform has a checkbox next to each material. I want for the end user to be able to click that check box and the following to happen:
1). Add a new record to tbl_Receipts that will log:
a). User Name (manually entered by associate)


b). Date (auto populated on the form)
c). Part Number
d). Qty
2). Save the record
3). Ability to check multiple lines and each click adds a new record

Once they are done receiving the materials for the current PO, they can click the "New Receipts" button and start the process again.


Here's what I've tried so far, and this works to pull the current line part number and qty up into the main form, but it doesn't push the data to the tbl_Receipts, nor will it allow me to click multiple lines, when I do that it just updates a single record so I can click 3 or 4 line items and only have one record in the table reflecting the last click (without username, partnumber and qty)

[/Private Sub Received_Click() Me.Parent.PartNumber = Me.SupplierPartNum
Me.Parent.Qty = Me.Qty
DoEvents
DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToRecord , "", acNewRec
End Sub]

[orange]

Have you checked the Similar Threads at the bottom of the page? Often can gain insight from such threads/posts.

[riley23258]

After taking your suggestion, I read through some of the similar posts. I'm pretty novice with VBA and SQL alike so it could be me just not understanding the answer is there, but I didn't see anything that was very similar to my problem.

[orange]

Can you post a copy of your database(zip format)? Doesn't have to be real data --any data sufficient to show the issue.
I'm sure you'll get more focused responses when readers can see/test the actual situation.