in the second form, though I'm not certain what "applying the filter" means.
> Are you using a parameter query? Is there code in the second form to
apply
> the filter? More details, please.
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf
> Of Ralphkru
> Sent: Sunday, May 07, 2006 6:40 AM
> To: [email protected]
> Subject: [ms_access] Simple Search problem
>
> I have a very simple database, 1 table, 1 query, 2 forms. One of
> the forms is based on the table and when it is opened, it opens
> at the first record, and all the other records are available via
> the controls. The second form, when it is opened, opens with two
> small boxes, one coming after the other, that ask for a search
> term from the user for one of two fields, or both. Upon
> supplying the term(s), the form opens but shows no data.
>
> I have input some trial data to test this, so I know I'm not
> asking for terms that don't exist. I have another database that
> does essentially the same thing, and does it successfully. I
> thought I was setting up this 2nd database the same way, but
> obviously I've forgotten something. I have tried comparing the
> two but cannot find what the difference is. Any ideas on what
> might be going wrong?
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
