Pasting values into a query

[Firedart]

Basically I have a list of numeric values in a column in excel, called IssueID. I also have an Access Database with the IssueID column, and lots of data related to the issue.

I want to be able to copy the IssueIDs from excel directly into an input box in access, which then queries the database and brings back the full records with those IssueIDs.

Anyone know how to do this?

Thanks!

 

[Remou]

You could build your own query using a textbox. Let us say you also have a subform to display these records.

strSQL="SELECT * FROM tblIssues " _
& "WHERE IssueID IN (" & Me.txtListOfIssueIDs & ")"

Me.sfrmIssues.Form.RecordSource=strSQL

http://lessthandot.com