Dual Combo pt 2

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Comob1 is working WDate. I have the code below inthe event
procedure of after update. Should anything be in the
RowSourceType? Not quite sure on how to do the SQL
Statment.
-----Original Message-----
Hi, Dan.

Set the 2nd combo box' Row Source to an appropriate SQL
statement, using the value in the 1st box as criteria.
I've assumed the Date field's name is WorkDate and the
Name field is StaffMember (Date and Name are reserved
words).

Dim strSelect As String
Dim strCrit As String
strSelect = "SELECT [tblname].[StaffMember] FROM tblname "
strCrit = "Where WorkDate = " & Me!1stcomboboxname & ";"
Me!2ndcomboboxname.RowSource = strSelect & strCrit

HTH
Kevin Sprinkel
-----Original Message-----
I have a form based off a query. I have a combo box which
I use to look up a date. I want to have a second combo box
to pull a person from that date. How do I go about this.
One Table
.
Click to expand...
.
Click to expand...
..
 
See post under original thread.
-----Original Message-----
Comob1 is working WDate. I have the code below inthe event
procedure of after update. Should anything be in the
RowSourceType? Not quite sure on how to do the SQL
Statment.
-----Original Message-----
Hi, Dan.

Set the 2nd combo box' Row Source to an appropriate SQL
statement, using the value in the 1st box as criteria.
I've assumed the Date field's name is WorkDate and the
Name field is StaffMember (Date and Name are reserved
words).

Dim strSelect As String
Dim strCrit As String
strSelect = "SELECT [tblname].[StaffMember] FROM tblname "
strCrit = "Where WorkDate = " & Me!1stcomboboxname & ";"
Me!2ndcomboboxname.RowSource = strSelect & strCrit

HTH
Kevin Sprinkel
-----Original Message-----
I have a form based off a query. I have a combo box which
I use to look up a date. I want to have a second combo box
to pull a person from that date. How do I go about this.
One Table
.
Click to expand...
.
Click to expand...
..


.
Click to expand...
 
See my post under the original thread.
-----Original Message-----
Comob1 is working WDate. I have the code below inthe event
procedure of after update. Should anything be in the
RowSourceType? Not quite sure on how to do the SQL
Statment.
-----Original Message-----
Hi, Dan.

Set the 2nd combo box' Row Source to an appropriate SQL
statement, using the value in the 1st box as criteria.
I've assumed the Date field's name is WorkDate and the
Name field is StaffMember (Date and Name are reserved
words).

Dim strSelect As String
Dim strCrit As String
strSelect = "SELECT [tblname].[StaffMember] FROM tblname "
strCrit = "Where WorkDate = " & Me!1stcomboboxname & ";"
Me!2ndcomboboxname.RowSource = strSelect & strCrit

HTH
Kevin Sprinkel
-----Original Message-----
I have a form based off a query. I have a combo box which
I use to look up a date. I want to have a second combo box
to pull a person from that date. How do I go about this.
One Table
.
Click to expand...
.
Click to expand...
..


.
Click to expand...
 
Back
Top