Select record?

[Kelsey]

Hi,
I have a subform Where you can choose InventoryID (2nd sub automatically shows records related to that InventoryID), and then select the correct PurchaseOrderDetailID.
The 2nd sub shows only instances of that InventoryID and when you select the PurchaseOrderDetailID in the first subform, I want that record in the 2nd sub to be selected as well.

[June7]

Don't understand the data structure and form setup. Do you want to provide project for analysis?

[Kelsey]

I can't upload, but hopefully this makes it a little more clear...

What happens is in sub1 you choose an InventoryID and the bottom subform pulls up a list of all the different batches of that InventoryID that we have. For example..

Batch Qty
2301 5
2380 15

In sub1, you are also required to enter in a Batch number. Default is the first one on the list, but there are special circumstances where you may need to select a different one. I have this code currently.

Private Sub IssueQuantity_BeforeUpdate(Cancel As Integer)
If Me.IssueQuantity > Me.Parent!FifoStock!OnHand Then
Cancel = True
MsgBox "Do not have enough" & vbNewLine & vbNewLine & "Field not updated", vbExclamation, "Invalid Entry"
End If
End Sub

But, if you DO choose a BatchID that is not the top one, the bottom subform doesn't know that you switched ID's to the 2nd on the list. So if I typed in Batch 2380 and tried to issue 6, it would tell me that I don't have enough.

[June7]

Still hard to visualize, so just a guess, but sounds like a form needs to be requeried after selection.

Why can't upload? Make copy, remove confidential data, run Compact & Repair, zip if large (2mb zip allowed), attach to post.