Here's what now have (working okay):
==>First, Update tblOutput with some criteria:
UPDATE tblOutput SET Wildcard = Forms!frmMain!frmCn!FindString;
==>Then, look for FindString through a number of stored queries based on
user criteria, for example:
SELECT [tblEntity].[Entity_ID]
FROM tblEntity
WHERE (([tblEntity].[Company]) IN (SELECT Wildcard FROM tblOutput))
OR (([tblEntity].[LastName]) IN (SELECT Wildcard FROM tblOutput))
OR (([tblEntity].[FirstName]) IN (SELECT Wildcard FROM tblOutput))
OR (([tblEntity].[Salutation]) IN (SELECT Wildcard FROM tblOutput))
OR (([tblEntity].[Title]) IN (SELECT Wildcard FROM tblOutput))
==>Then, create the recordset:
If Me.Condition=True Then Set rst = CurrentDb.OpenRecordset("SELECT
tblTable.Row FROM tblTable WHERE ((tblTable.Entity_ID) IN (SELECT Entity_ID
FROM " & strSearchQry & "))")
==>"strSearchQry" is one of several stored queries that are run based on
user selected criteria.
==>"tblTable.Entity_ID" is a foreign key from tblEntity
Now that I have all the tblTable.Rows (that were defined by user input in an
unbound form field) in a recordset, I can do all kinds of cool stuff. As
far as I know, the above routine is the only way to accomplish this. Bottom
Line: unbound data is a bad thing.
"Larry Linson" <bo*****@localhost.net> wrote in message
news:MX*******************@nwrddc02.gnilink.net...
How many of these little one-record tables are you likely to spread
around, cluttering your database, and how in the world do you plan to manage and
actually use that many tables? I suggest you reconsider: an Append query
will not overwrite something -- not unless there's some humungous bug in
Access that we don't know about.
Larry Linson
Microsoft Access MVP
"deko" <dj****@hotmail.com> wrote in message
news:jS******************@newssvr25.news.prodigy.c om... I need to create different recordsets based on queries that use data
from unbound fields in a form. I've discovered that I can't do this, and
instead need to save the data in question (usually a text string) to a table.
I'm thinking the best way to do this is to use a Make Table query --
that way the table stays small -- one row -- and there is less chance for
something to get overwritten.
But how to create a make table query from unbound data?
SELECT Forms!frmMain!frmCn!FindString INTO tblSearch; -- this fails....
any suggestions welcome!
thx in advance!