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®
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®