After adding Query (1 Viewer)

Bandara

Member
Local time
Today, 17:46
Joined
Apr 17, 2020
Messages
60
I create a form with combo box. Then I added a button with query and combo box connected with button by using this code [Forms]![Form1]![Combo0]. If I add this the form Combo box only shows 1 value. If removed the code it shows all values. How to fix this?
 

Attachments

  • ACCESS !.png
    ACCESS !.png
    30.9 KB · Views: 292

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:16
Joined
May 7, 2009
Messages
19,175
change the Criteria to:

IIF(Trim([Forms]![Form1]![Combo0] & "") = "", [ASSET TYPE], [Forms]![Form1]![Combo0])
 

Users who are viewing this thread

Top Bottom