I have created a Kiosk Information Form where you select a name from and "Owners" table and that name gets recorded onto the "kiosk" table so it shows what owners own what kiosks.
What i have done is created a combo box that you would be able to select from a list of different owners in the database
Dim SQL As String
SQL = "Select * from Owner"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = SQL
Do Until Adodc1.Recordset.EOF
So you select the owners lastname from the list. What i want to happen is when i select the specific owner from that list, that his information would get populated into the different textboxes i have setup.
So if i selected Peter from the list. All the information from Peter should appear in the different textboxes.