OnClick Form1 Opens Form2 - Need Form2 To Open With ID On Form1

[wbwalsh]

Note: DataGridView is not used in this project.

Form1 is bound to table tbl_Offenders (MS Access DB). Form2 is bound to table tbl_Vehicles (MS Access DB). Form1 has a button that opens Form2 as ShowDialog. Currently when Form2 opens all records are showing in a combo box. Form2 functions correctly (add, delete, edit, scroll, etc.). The problem is that I need Form2 to open with filtered records. Form2 needs to open showing only the records where the ID field (txt_CARDS_ID) from From1 matches the ID field from From2 (txt_CARDS_ID).

I apologize if this is an easy issue that I should already know… I’ve checked many sites and the only examples I found were for DataGridView and I could not make the examples work in my project.

 

[wbwalsh]

FYI: This is the load event for Form2
Me.Tbl_VehiclesTableAdapter.Fill Me.Cards_dbDataSet.tbl_Vehicles)

 

[wbwalsh]

** I left the first ( off the previous post. The fill on load is working fine... just wanted to show the load code. **
Me.Tbl_VehiclesTableAdapter.Fill(Me.Cards_dbDataSet.tbl_Vehicles)