SQL Select using a combobox value as WHERE 1

[pdddms]

Hello i am not too good at SQL, i usually use SELECT * to do fill recordsets. my issue is that i am not able to get the correct record to pass to my datareport. I use Jet4.0 I want the query to be structured like this.
SELECT FROM [MINORCHILDREN] WHERE !name=combobox1.text

where !name is the specific field to match for the correct record.

Part 2 is then right now i have my
rtp.datasource=rsMinorChildren.datasource
would i be better off saying:
rpt.datasource = SQLSTATEMENT?

Thanx,
Stew

LoL Concepts®

http://www.lolconcepts.com

 

[johnwm]

A quick search on this forum, using 'datareport' will yield a number of answers, including
thread222-453903
thread222-472900
thread222-638319

Try those first and come back if you need further assistance

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[pdddms]

johnwm-
as always. thank you so much for your help. the second thread helped me out tons. Oh ya, thanks for the quick reply!

LoL Concepts®

http://www.lolconcepts.com