Updating a subform records based on a combo box selection in the Main form with VBA code. Not OK.

[NKB]

I'm not experienced enough to say whether these are the reasons NKB but my two observations from your database are that your main form wasn't bound to a table and that you had no relationships set up so the wizard wasn't able to set anything up successfully.

andy49

Contrary to what you said, my main form is bound to tblPurchases. As for the relationships, I always make sure that relationships among my tables are established well in my DB files to reap benefits in Forms, Reports and Queries. In fact, I spent quite some time learning relationships and I think I am good at them now. The only thing that puzzles me now is the blue line that Mayer suggested which is : Me.Recordset.FindFirst "[PurchaseID] = " & Me!cboPurchaseID in my opinion it solved the problem. Honestly, I debugged my code for long hours and days, printing to the immediate window every bit of the code, and I could not figure out the problem and that's when I turned to the experts in this useful Forum. Andy49, thanks again for the help. This dialogue is helping me become strong in MS Access.

[Mayer]

NKB, you are welcome
You linked a subform to a bound form, so when main form's PurchaseID value is 1 or 2 or 3, etc., linked subform will display data which has same PurchaseID vale, you can read about linked subform on office help, now you can replace your code with the following:

Private Sub cboPurchaseID_AfterUpdate()
Me.Recordset.FindFirst "[PurchaseID] = " & Me!cboPurchaseID
End Sub

I hope that could help<<