Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create recordset from recordsource?

Status
Not open for further replies.
RSGB

RSGB

Technical User
Feb 14, 2001
45
0
0
GB
Hi

I have a question I can hope you can help me with...

I have a reusable form and want to create a recordset based on the form's recordsource which contains distinct values in one of the fields.

So I guesss something like:

mySQL = "Select distinctrow JobNumber from " & myForm.recordsource
set myRST = currentdb.openrecordset (mySQL)

Any thoughts on where I'm going wrong?

Cheers

RSGB
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
113
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
173
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
183
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question
Create query that will divide work among employees 1
Replies
7
Views
96
Andrzejek
Andrzejek
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
204
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top