text box to query

G

Guest

Hello all,

I have two forms
1) text box (txToteLkUp) on it, once populated with search criteria the user
clicks the text box and opens:
2) form )fmQry) with list box. This listbox Row Source is a query
(qrItmLkup), getting its criteria from the txToteLkUp.

When I enter in the txToteLkUp and have the query set to get the text info
[forms]![fmLookup]![txToteLkUp]
The list box will be empty, however if I add the search criteria to the
query itself and click from the first form it works.

Is a list box attached to a query unable to use text box as the criteria?
 
G

Guest

okay, maybe there's a bug here. In a query I have added [What number are you
looking for?]. This pop's up a box and lets you add info for a criteria.
This work's in the other database I have, but for some reason not in the db
I'm working on now. Is there something that can turn this off/on? I am
running access 97. thanks for any info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Text Box to Enter Criteria 3
Query problem 4
Filtering A Crosstab Query Dynamically 1
Query base on list box 1
Query Tied to Form doesn't work 7
Multi-select list box as query parameter 15
Combo Box Value List/Query Criteria 3
query variables 2

Top