Query with parameter from form control returns no records - HELP P

Query with parameter from form control returns no records - HELP P

Post by RGFsZSBGeW » Wed, 25 Mar 2009 02:58:10


Teddy,

Try defining the parameter. You can do this one of two ways (through the
SQL view, or through the query design view). In SQL view, paste the
following line at the beginning of the SQL statement for the reports query:

Parameters [Forms]![frmLabelPrinting]![cboCustomerType] Long;

If you do this via the query design view, right click in the gray area where
the tables sit in the query. Select the Parameters option, then paste the
control reference in first row on the left, and select the Long datatype for
the column on the right.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
 
 

1. Creating a Query form that will return all records based on two parameters

2. Return results from a parameter query using a custom form back into the original form....

Ok, this is my last obstacle on my first Access project. What I have
is a form that users can scroll through all of the shops we deal with,
about 900. On the bottom of this form are buttons A-Z so filter the
form to only shops that start with those letters, and an ALL button to
list all the shops again. I made a search button to be able to bring
up a custom form where users can search by any part of a shop name,
address, or zip. I have a marco attached to a search button to run the
parameter query. Everything works fine, except that the filtered
result show up in a spreadsheet view. Could someone please provide
some code or instructions to get the filtered search results to show
up back in the original form? Thanks in advance.....

3. Query by form to return 1 record, displayed in another form.Ca

4. Query by form to return 1 record, displayed in another form.Can I

5. When Filtering Query - Query returns no records when there arer matching records

6. Parameter query returning information in form view

7. Searching for a record (parameter query from a form)

8. open form bases on parameter query and goto last record

9. Form based on parameter query only showing one record at a time

10. Sum in report footer gives error when control source query returns no records.

11. Using SQL Query Code in Form Module to Return Record Count

12. Restrict number of records returned by query on form

13. Form bound to a query does not return the correect records.

14. Parameter queries don't find form controls in copies of my fro

15. GUID on form used in query (no records returned)