Re: Query Results in multiple text boxes
- From: pfm721 <pfm721@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 May 2008 06:30:01 -0700
My problem is not that it returns more than one record. In this particular
instance the way that they data is populated it will only return one record
or no record. Sorry if I am confusing you. Currently the user inserts a value
in a combo box that is tied to a parameter query. Then the user clicks on a
command button that runs the query. When the query runs it pops up a data
sheet with the record that I want. What I would like to do is make it return
the results on the search form itself. I tried to do that with the text boxes
and Dlookups but it doesn't seem to work if I put more than one text box on
the form. I tried to have it display the results in a list box, but I was
unable to get the list box to refresh when I run the search a second time.
Finally I still have not been able to stop the query results window from
popping up. I appreciate any help with this as I am fairly nex to this.
Thanks.
"Larry Daugherty" wrote:
Base your form on a query that uses the "TOP n" predicate, in this.
case, TOP 1. That will return just one record.
HTH
--
-Larry-
--
"pfm721" <pfm721@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AB52FF4C-980D-45FA-AD53-0BA2759E5ECF@xxxxxxxxxxxxxxxx
Currently I have a form that takes a user input and runs a parameterquery
returning only one record at a time. When it returns the record Iwould like
it to display the results on the search form and not in a pop upwindow. What
would be the best way to go about it? I tried to use 4 text boxeswith some
variation of this code =DLookUp("[APC]","qryAPClookup") to look upthe four
fields in the query but it doesn't work when there is more than onefor some
reason. Any ideas?
- References:
- Query Results in multiple text boxes
- From: pfm721
- Re: Query Results in multiple text boxes
- From: Larry Daugherty
- Query Results in multiple text boxes
- Prev by Date: Re: Refill Combobox for each row
- Next by Date: Default Value not passing to table
- Previous by thread: Re: Query Results in multiple text boxes
- Next by thread: Default Value not passing to table
- Index(es):
Relevant Pages
|
