Hey everyone...

Right now, when my form1 loads it fills a datagrid with the top 10 records of from a table called CUSTOMERS.

Then I have it so I can press Shift + Enter to Update the selected record in the datagrid. So then it opens a new form and displays the information in individual textboxes for updating.

Here is what I need to do...

When the User Presses just the "Enter" key on form1's datagrid...it then needs to open another form which contains all INVOICES that correspond with the selected Record. I want to fill another datagrid with the invoices!


Here is my DB design.

Table name - CUSTOMERS
Field Names - CUS_NUMBER, CUS_FIRST, CUS_LAST, CUS_PHONE
(there is some more but they are not relevant for this part)

Table name - INVOICES
Field Names - INV_NUMBER, INV_DATE, INV_AMOUNT, INV_PAID


Thanks for the help in advance!