parameter to query from option group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
What is the appropriate syntax to referenc the value of an option group in a
query? I currently have:

CODE
Like
IIf([Forms]![frmMain]![fraBusType]![value]=2,'*',[Forms]![frmMain]![fraBusType]![Value])
But that doesn't seem to work.

Thanks,
 
Too many bangs... need a dot. (Or take out the value property)

IIf([Forms]![frmMain]![fraBusType].value=2,'*',[Forms]![frmMain]![fraBusType].Value)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query driven by form field 1
using IIF to determine form state 2
12 query criteria from "Search" form... 8
Using Like in Criteria of a Query 1
insert a crosstab in to temp table query 2
Criteria for Query 2
Filter date 2
Queries & multiple Form inputs 1

Back
Top