F
Fie
hey...
Iv found some code that allowes user to select from a option group then
results appear in list box. But am unsure what this code should be
attached to/where to put it..
Also i understand most of it but I am confused as to what
[By Search Type].RowSource = "SELECT................"
does this ref the query you are working from looks like SQL to me??
HELP
code is:
Private Sub Type_of_Search_AfterUpdate()
If [Type of Search].Value = 1 Then
[By Search Type] .RowSource = ""
[Search Text].Caption = "Select the School Name to Search For"
[By Search Type].ColumnCount = 3
[By Search Type].ColumnWidth = "2 in;1 in;0 in"
[By Search Type].BoundColumn = 3
[By Search Type].RowSource = "SELECT................"
ElseIf [Type of Search].Value = 2 Then
[By Search Type].RowSource = ""
[Search Text].Caption = "Select the Cost Centre to Search For"
[By Search Type].ColumnCount = 2
[By Search Type].ColumnWidth = "1 in;2 in"
[By Search Type].BoundColumn = 1
[By Search Type].RowSource = "SELECT............"
End If
End Sub
Any1 got any idea????
Iv found some code that allowes user to select from a option group then
results appear in list box. But am unsure what this code should be
attached to/where to put it..
Also i understand most of it but I am confused as to what
[By Search Type].RowSource = "SELECT................"
does this ref the query you are working from looks like SQL to me??
HELP
code is:
Private Sub Type_of_Search_AfterUpdate()
If [Type of Search].Value = 1 Then
[By Search Type] .RowSource = ""
[Search Text].Caption = "Select the School Name to Search For"
[By Search Type].ColumnCount = 3
[By Search Type].ColumnWidth = "2 in;1 in;0 in"
[By Search Type].BoundColumn = 3
[By Search Type].RowSource = "SELECT................"
ElseIf [Type of Search].Value = 2 Then
[By Search Type].RowSource = ""
[Search Text].Caption = "Select the Cost Centre to Search For"
[By Search Type].ColumnCount = 2
[By Search Type].ColumnWidth = "1 in;2 in"
[By Search Type].BoundColumn = 1
[By Search Type].RowSource = "SELECT............"
End If
End Sub
Any1 got any idea????