Form1 (not datagrid) works great (add, delete, edit, scroll, etc..). Form1 uses table tbl_Offenders. tbl_Offenders has field(key) called CARDS_ID. CARDS_ID is a numeric, autonumber field.
Form2 (not datagrid) works great also. Form2 uses table tbl_Vehicles. tbl_Vehicles has a field(also a key) called CARDS_ID. CARDS_ID is a numeric text field. Form2 opens on a button located on From1. When Form2 open and the “Add” button is pressed, a new record is created with a text field (txt_Cards_ID) populated with the current selected record on Form1.
So I have two forms using two tables each with a CARDS_ID field. What I need is that when Form2 opens by pressing button on Form1, Form2 should only display records where the CARDS_ID field in Form2 (tbl_Vehicles) match the CARDS_ID field in Form1 (tbl_Offenders).
I have heavy Access knowledge and could setup Access forms to do this task… however I have begun to use Visual Studio (VB) and need help on this one issue. I’m using the designer to setup/load the forms, not using sql code directly in form.
Thanks for any help!!!