List box as filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a list box and a button. The list box is populated with a
list of dates from a table. The button opens a report that is run from a
query that uses the selected dated in the list box as a filter. But it
doesn't give me anything. When I open the report with out using the form it
asks me for the date and filters properly. Here is the SQL from my query.

SELECT [Journal Entries].Date, [Journal Entries].[Line #], [Journal
Entries].[Store #], [Journal Entries].[Ref #], [Journal Entries].Debit,
[Journal Entries].Credit, [Journal Entries].Net, [Journal Entries].Reason,
[JE Codes].[JE Number], [Journal Entries].[Printed/Exported], [Journal
Entries].A3, [Journal Entries].[Entered By], [Journal Entries].[Date Printed]
FROM [JE Codes] RIGHT JOIN [Journal Entries] ON [JE Codes].[JE Code] =
[Journal Entries].Reason
WHERE ((([Journal Entries].[Printed/Exported])=True) AND (([Journal
Entries].[Entered By])=fosusername()) AND (([Journal Entries].[Date
Printed])=[forms]![frm:JE Reprint]![Date Printed]));


Why won't it work when I use the forms button. It just gives me a blank
report.
 
Please ignore this post as I just figured out my issue. I put a space where
one was not needed.
 

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

Back
Top