Passing a Parameter to a Form when Opening

[Paul Fairless]

I have a form called frmCustSearch to search for customers against an SQL
Server database.

The form contains a simple textbox into which the Customers surname is
typed, and a datagrid then becomes visible on the form containing the
CustID, Surname, Forename and address of all people with that surname.

The correct customer is then selected from the datagrid and I want to open a
new form called frmCustomer to display all the details for that customer,
using the CustID as an argument when opening the form so that it can
retrieve the customer record from the database during its load event.

This is similar to using the OpenArgs in MS Access.
But how do I achieve this in VB.NET?
Your help is much appreciated.

Paul

[Cor]

Hi Paul,

The best thing is first to look at the capabilities of the SQL server
version you are using.

For searching that is not for all the same and there are lot of different
possibilities.

I hope this helps?

Cor

I have a form called frmCustSearch to search for customers against an SQL
Server database.

The form contains a simple textbox into which the Customers surname is
typed, and a datagrid then becomes visible on the form containing the
CustID, Surname, Forename and address of all people with that surname.

The correct customer is then selected from the datagrid and I want to open a new form called frmCustomer to display all the details for that customer,
using the CustID as an argument when opening the form so that it can
retrieve the customer record from the database during its load event.

This is similar to using the OpenArgs in MS Access.
But how do I achieve this in VB.NET?
Your help is much appreciated.