David Ball
Registered User.
- Local time
- Today, 12:04
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
I have a query based on two joined tables. There is a report based on the query. I had a parameter query set up where a user could enter a Job Number and the report would open up filtered for just that job number.
I want to have a list box on a form where the user can select a job number from the list box rather than have to remember them.
The problem is, when I run this the query is modified somehow. One of the tables that the query is based upon disappears from the query and all fields, except Job Number, are removed from the query.
Why would this happen?
Thanks very much
Dave
I have a query based on two joined tables. There is a report based on the query. I had a parameter query set up where a user could enter a Job Number and the report would open up filtered for just that job number.
I want to have a list box on a form where the user can select a job number from the list box rather than have to remember them.
The problem is, when I run this the query is modified somehow. One of the tables that the query is based upon disappears from the query and all fields, except Job Number, are removed from the query.
Why would this happen?
Thanks very much
Dave