HerickPaiva
May 2nd, 2001, 10:12 AM
Hi,
I have a form with a combobox and 4 textboxes. ComBoBox displays list of records from field ("sourcefilename"):
With rs
'Are there any records?
If .BOF And .EOF Then
Exit Sub
End If
'Load the control, starting from the record
'current in the recordset
Do Until .EOF
cmbFiles.AddItem .Fields("SourceFileName").Value
cmbFiles.ItemData(cmbFiles.NewIndex) = .Fields("UploadID").Value
.MoveNext
Loop
End With
Now, I need to be able (in runtime) when I click one of the records in the combobox, the other 4 textboxes need to display the related records for the selection. What do I need to do? Binding each textbox to a field, or code somehting so that it changes and soon as I select a record in the ComboBox??
THanks,
I have a form with a combobox and 4 textboxes. ComBoBox displays list of records from field ("sourcefilename"):
With rs
'Are there any records?
If .BOF And .EOF Then
Exit Sub
End If
'Load the control, starting from the record
'current in the recordset
Do Until .EOF
cmbFiles.AddItem .Fields("SourceFileName").Value
cmbFiles.ItemData(cmbFiles.NewIndex) = .Fields("UploadID").Value
.MoveNext
Loop
End With
Now, I need to be able (in runtime) when I click one of the records in the combobox, the other 4 textboxes need to display the related records for the selection. What do I need to do? Binding each textbox to a field, or code somehting so that it changes and soon as I select a record in the ComboBox??
THanks,