getting data from one form to another.

Expand Post »

i wondered if anyone could help me with this.

i have a button on a form (frmUpdateProduct). this button opens up another form (frmSelectSupplier). i have a listbox which gets all the supplier names from the access database, and assigns then with the Supplier ID (also from the database). here is the code for the listbox:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Private Sub form_activate()
Set m_colSuppID = Nothing
    Set m_colSuppID = New Collection
 
    strSQL = "SELECT [supplier_ID], [SupplierName] FROM [Supplier]"
    With con
        .Open
        Set RP = .Execute(strSQL)
    End With
    With RP
        lstSupplier.Clear
        Do Until .EOF
            lstSupplier.AddItem "" & !supplierName
            m_colSuppID.Add CStr(!supplier_ID), "" & !SupplierName
            .MoveNext
        Loop
        .Close
    End With
    con.Close
End Sub
Private Sub form_activate()
Set m_colSuppID = Nothing
    Set m_colSuppID = New Collection
    
    strSQL = "SELECT [supplier_ID], [SupplierName] FROM [Supplier]"
    With con
        .Open
        Set RP = .Execute(strSQL)
    End With
    With RP
        lstSupplier.Clear
        Do Until .EOF
            lstSupplier.AddItem "" & !supplierName
            m_colSuppID.Add CStr(!supplier_ID), "" & !SupplierName
            .MoveNext
        Loop
        .Close
    End With
    con.Close
End Sub

i need to get the supplier name/ supplier id, to be sent to a text box (frmUpdateProduct.TxtSupplier.text). how would i do this?

Similar Threads

get posted form data in python in Python
Login and retrieve user data from database in ASP.NET
load data from access database into form in VB.NET
why isn't this booking form working. in ASP
How do I get the data collected in a VB form into specific locations in word 97 doc in Windows Software

skalra63

Reputation Points: 13

Solved Threads: 0

Light Poster

Offline

30 posts
since Feb 2006

Permalink

Mar 7th, 2006

Re: getting data from one form to another.

2 ways :

You can have the Supplier data (Name, Id) as global variables. From form1 (SelectSupp) set the values of the globals and then open form2(UpdProduct). Then u can access the global variables from form2. Frankly, some programmers don't like to use globals, so the second method is better.

Declare a public function in form1 that shows the SuppName.
Public ShowSuppName() as String
ShowSuppName = lstSupplier.Text
End Function

Then call this function from form2 after it has been loaded
txtSupplier.text = form1.ShowSuppName()

aparnesh

Reputation Points: 20

Solved Threads: 10

Junior Poster

Offline

193 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: This has to be a simple question to answer.

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: I want to have a nested scrollable area (with buttons and controls) inside a dialog.

DaniWeb Message

Cancel Changes

User Name
Password