Multiple sources for controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three controls on a form. The form is laid out as follows:-

********************************************************
Select ID number from list [ Combo Box 1]
OR
Enter Keyword [Text Box 1]

Results [List Box 1]
********************************************************

What I'm trying to do is to allow the user of the form to either enter an ID
number which would return a specific record, or for him to enter a keyword,
which would return several records that inculde the keyword.

What I dont know how to do is to allow [List Box 1] to respond to either the
value returned from [Combo Box 1] or [ Text Box 1], depending on which one is
filled in!
 
Set the value of ListBox1 in the AfterUpdate of each control.

Private Combo1_AfterUpdate()
ListBox1 = Whatever from Combo1
End Sub

Private Text1_AfterUpdate()
ListBox1 = Whatever from Text1
End Sub
 
Thanks Brian...I'll give it a try

Phil

Brian said:
Set the value of ListBox1 in the AfterUpdate of each control.

Private Combo1_AfterUpdate()
ListBox1 = Whatever from Combo1
End Sub

Private Text1_AfterUpdate()
ListBox1 = Whatever from Text1
End Sub


Phil said:
I have three controls on a form. The form is laid out as follows:-

********************************************************
Select ID number from list [ Combo Box 1]
OR
Enter Keyword [Text Box 1]

Results [List Box 1]
********************************************************

What I'm trying to do is to allow the user of the form to either enter an ID
number which would return a specific record, or for him to enter a keyword,
which would return several records that inculde the keyword.

What I dont know how to do is to allow [List Box 1] to respond to either the
value returned from [Combo Box 1] or [ Text Box 1], depending on which one is
filled in!
Click to expand...
Click to expand...
 
Back
Top