Private Sub List1_Click()

Data2.RecordSource = "select * from prices where subkey = '" & _

                            List1 & "' order by subkey"



can anyone tell me if i can add to the select statement so that subkey = 

list 1 and Psupp = ea



Psupp is another field and ea is text in that field.

Try it and see!



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

Extension 8487



-----Original Message-----

From: chris angus [mailto:chris@a...]

Sent: Thursday, October 25, 2001 1:50 PM

To: Access

Subject: [access] another bit of help please





Private Sub List1_Click()

Data2.RecordSource = "select * from prices where subkey = '" & _

                            List1 & "' order by subkey"



can anyone tell me if i can add to the select statement so that subkey = 

list 1 and Psupp = ea



Psupp is another field and ea is text in that field.