Created function as criteria

[BillMc]

Hi.


I need to add string chosen from my combo box on the form to a query as filtering criteria. It didnt work directly so I loaded the chosen line from combo box by function. Then I used this function as criteria for query. It worked but I couldnt handle case when I dont choose anything from the combo box and in such case I would like to see all records. Insted of that it filtered out all records so I dont see any as result of query. Could u please help me? Thanks a lot

[orange]

Please show related code.

[ketbdnetbp]

You might be able to use the following in the criteria row of the query.

[Forms]![myForm]![myCombo] OR [Forms]![myForm]![myCombo] Is Null

Change the names to reflect the name of your form and combo.

Hope this helps,

Jim

[ketbdnetbp]

Sorry, didn't see your post before I replied.

All the best,

Jim

[BillMc]

Dear Jim.
Thanks for your suggestion but from some unknow reason this was not working so thats why I used function
Function F1()
F1=[Forms]![myForm]![myCombo]
and than F1() was used as criteria in query which worked perfectly but I was not able to handle case where none of item from combo was chosen. Maybe the problem is that I am not able to find any controls for adding(not this combo nor textboxes) from my form when I use builder in query for adding criterias..... Thanks in advance
Martin

[ketbdnetbp]

Not sure I understand -

"Maybe the problem is that I am not able to find any controls for adding(not this combo nor textboxes) from my form when I use builder in query for adding criterias."

Can you post the db, less all sensitive data? Compact and repair, first, then zip.

Thanks,

Jim