error in IIf statement

R

RPrasad

Board Regular
Joined
Mar 22, 2008
Messages
144
I am passing on the parameters using combobox to a query. When I select individual region its working fine. However when I select "All" in the dropdown the query should display all regions data...and I am struck up here. Please help.

Code: 
 IIf([Forms]![FrmMain]![cmbReg]="ALL","like *",[Forms]![FrmMain]![cmbReg])
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
If in your combo box, you remove the ALL. In your query, in the criteria, type
Code: 
Like Forms!frmMain.cmbreg & "*"

If you leave the combo box blank in your search form, it should bring back all the records.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
IIF statement for query
Replies
3
Views
492
welshgasman
welshgasman
MCTampa
  • Solved
Mixing Number and Text Query Criteria from a Form
Replies
5
Views
591
MCTampa
MCTampa
C
  • Question Question
VBA code for Next button to move to each record in Textbox1
Replies
2
Views
499
welshgasman
welshgasman
J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
949
Micron
M
B
  • Solved
Access Formula Error
2 3 4
Replies
39
Views
2K
Micron
M

Forum statistics

Threads
1,224,560
Messages
6,179,520
Members
452,921
Latest member
BBQKING

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top