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)
 
Back
Top