christakis
Registered User.
- Local time
- Today, 15:05
- Joined
- Oct 23, 2009
- Messages
- 72
Hi guys,
I am trying to create a form which is split into two parts to filter the records of a table. The top part will have search fields and the bottom part will show the results of a query.
I managed to create the query to filter assets based on the Preferred field of table "comAssets". The query should read the contents of combo box cboPref in form "Form1" and filter accordingly.
If cboPref is null then the query returns all records (works ok) but the query fails for any other value of cboPref. Since the query works fine when the form is closed and you manually type in the value, I suspect the combobox is to blame. This is also the reason I posted this problem under Forms.
cboPref provides options based on table tblValues.
I know nothing makes sense to you so far so I included the database for you to play with. This is a very trimmed down version of the original but you should get a basic idea of what I am talking about.
I would also appreciate if you could explain me how to get the query results to show in the form.
Best Regards,
Christakis
I am trying to create a form which is split into two parts to filter the records of a table. The top part will have search fields and the bottom part will show the results of a query.
I managed to create the query to filter assets based on the Preferred field of table "comAssets". The query should read the contents of combo box cboPref in form "Form1" and filter accordingly.
If cboPref is null then the query returns all records (works ok) but the query fails for any other value of cboPref. Since the query works fine when the form is closed and you manually type in the value, I suspect the combobox is to blame. This is also the reason I posted this problem under Forms.
cboPref provides options based on table tblValues.
I know nothing makes sense to you so far so I included the database for you to play with. This is a very trimmed down version of the original but you should get a basic idea of what I am talking about.
I would also appreciate if you could explain me how to get the query results to show in the form.
Best Regards,
Christakis