Trouble populating a Combo Box using a Passthrough Query

[Toga]

I am trying to learn how to use passthrough query's to populate a combo box I have. Either of these 2 commands work so I have a successful connection to the server.

Set rstSeqID = DISTDBC.OpenRecordset(xsql, dbOpenDynamic)
Set qdfTest = DISTDBC.CreateQueryDef("PassThruTest", xsql)

Which should I use and how in the world do I et from here to populating my Combo Box with the results?

Thanks...Toga

 

[tlbroadbent]

You can use a saved pass-through query as the ComboBox Row Source. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Toga]

Thanks....I did figure out how to save the passthrough in my currentDB and use it as my recordsource. While that worked fine, I was hoping I wouldn't have to do that as that means I have to delete & recreate that query each time I access my drop down.....unless I set up some sort of scheme for periodic delete & recreate.

Admittedly I don't know, but it feels like I'm gaining speed via bypassing the jet and then I loose my gain by having to save it before I can use it.

Is there anyway to use the passthrough results without first having to save it? Sorry if this is a dumb question but I did qualify my ignorance by saying I was trying to learn....

Toga

Yes....I did post this in more than one forum...sorry

 

[Toga]

Actually, I didn't understand your reply at first. I was in a different mindset I guess but you are right....I think using the saved pass-through queries are really going to be the ticket!

 

[waghorncp]

waghorncp (Programmer) Feb 2, 2002
I have a suite of queries running under a vba module in access 2000, using DoCmd().
I want to execute the access queries or preferably the VBA module holding them from (vba in) excel.
The idea is to have command buttons to i/p -process-o/p the data from excel. The database is too big for excel to handle but the i/p data is only 200 records.
Has anyone done this or similar.

 

[tlbroadbent]

waghorncp,

Please start a new thread for new questions. Also, I recommend posting your question in the Micosoft Office forum.

Thanks, Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com