Man, you are really confused about these object works. You didn't perform a query against that database at all. All you did was create a blank recordset, add some columns to it, then bound the empty recordset to a datagrid. You need to actually execute a query against the database. Something like this will return all the records in the specified table: Dim rs As New ADODB.Recordset Dim conn As New ADODB.Connection conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & \_ "C:\\Program Files\\Testing\\v003\\databases\\db1.mdb;Persist Security Info=False" rs.CursorLocation = adUseClient rs.Open "_tableName", conn, adOpenStatic, adLockReadOnly, adCmdTable Set DataGrid1.DataSource = rs_ This probably won't run as listed. I haven't used VB6 in over 5 years now... RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I recommend using parametized queries. See the documentation for the Parameters property of the OleDbCommand/SqlDbCommand classes. With parametized queries you avoid problems like invalid characters (a quote for example) or someone trying to hijaack your database by inserting SQL statements. EDIT: See this[^] post. -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!

You need to make the event handler method for the button click on Form2 public and within it check what control it is handling: Public Sub Search(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click If sender.GetType Is GetType(Form1) Then MsgBox("Button Called By Form 1") ElseIf sender Is GetType(Button) Then MsgBox("Button Called By Button") End If End Sub Then from the other form you can call this method in the load handler: Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim form1Instance As New Form1 'Only if you don't have another instance form1Instance.Search(sender, e) End Sub Hope this helps, although maybe you want to rethink your design a bit though and have a another class that performs the search that each form could access independently: Public Class Search Public Shared Sub DoSearch(ByVal sender As Object, ByVal e As EventArgs) If sender.GetType Is GetType(Form1) Then MsgBox("Button Called By Form 1") ElseIf sender Is GetType(Button) Then MsgBox("Button Called By Button") End If End Sub End Class You could then call this from anywhere without even creating an instance of the Search class using: Public Sub Search(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Search.DoSearch(sender, e) End Sub Cheers Tom

If you are usinig VB .NET you could easily just set the combobox datasource to the dataset you are going to use for it and then set the displaymember property to the field in the dataset in the properties box of the combobox.

Hey, From your problem, you could use inheritence in vb.net where you can use controls from one form in another using all the code behind the controls also. Here[^] is a good article Chris

tried both, no avail the key does exist cuz i copied and pasted the key into my script has to be some where else in the registry that changes the PC name

If you only put last name, the SQL statement will be like SELECT * FROM Users WHERE Last_Name = 'LName' AND FName = '' Most likely it won't return you anything as there won't be a person with FName = '' The easiest way is to use AND FName LIKE'" & strSearchFName & "%'" The recommended way is to make sure your SQL is correct (build a dynamic SQL, e.g. remove FName from condition if FName is not supplied) Hope it helps, Edbert P. Sydney, Australia.

I'm just taking a stab here but why are you assigning a recordsource property when in actuality you're executing a sql action statement? If you're using VB6 and ADO, you can use the connection object's 'execute' method to execute a sql statement, after which you can refresh your recordsource. *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";

Write a VBScript and use the Command scheduler. *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";