Show edible recordset in form

[Guest]

The user needs to pull up records by specific quarters or product types from
a form.

qtr ProdType

2004-01
2004-04
2004-07

 

[PC Datasheet]

Access is very good but I don't think it has any recordsts you can eat!

 

[Guest]

Edible recordset! Now there's a solution to world hunger....

 

[Marshall Barton]

The user needs to pull up records by specific quarters or product types from
a form.

qtr ProdType

2004-01
2004-04
2004-07

Aside from jokes about your typos, I don't see enough
information in your post to figure out what you're trying to
do.

 

[Rob Oldfield]

Perhaps...

set rs=db.BakeRecordSet("select * from ingredients where item<>'spinach'",
dbWithSideSalad)

But seriously.... what's the question? If you're grouping records by
quarter (or whatever) via a group query then the results aren't going to be
editable. You could use a make table version of the query and then base the
form on that but I'm not quite sure if that's what you're asking. Any use?

 

[PC Datasheet]

set rs=db.BakeRecordSet("select * from ingredients where item<>'spinach'"
and where item<>'eggs'"
dbWithSideSalad)

I hate eggs, too!!

 

[Guest]

I apologize for the incomplete question. Got interrupted and accidently sent
the incomplete question to the newsgroup. I did repost the full question as
"Recordset Filters" and will attempt to work through Mr. Snell's suggestions.