how can i write IIF statement when i use radio button

[choymns]

I created a form Contains a text box to search in name field
and two radio buttons , One to search at the beginning of the Name field and the other to search at any part of the field
I also created a button to open the search query and I wrote IIF statement as
IIf([Forms]![form name]![radio button name].[OptionValue]= -1 ;([table name].[name field]) Like "*" & [Forms]![form name]![text box name] & "*";([table name].[name field]) Like [Forms]![form name]![text box name] & "*")


but it not work correctly , Where error in IIF statement
and what The best way to create this form
I am new to access. Please help

[hertfordkc]

iif(test, truepart, falsepart), i.e. commas, not semicolons.
I didn't look for other errors which may be present.

I created a form Contains a text box to search in name field
and two radio buttons , One to search at the beginning of the Name field and the other to search at any part of the field
I also created a button to open the search query and I wrote IIF statement as
IIf([Forms]![form name]![radio button name].[OptionValue]= -1 ;([table name].[name field]) Like "*" & [Forms]![form name]![text box name] & "*";([table name].[name field]) Like [Forms]![form name]![text box name] & "*")
but it not work correctly , Where error in IIF statement
and what The best way to create this form
I am new to access. Please help

[ssanfu]

I created a form Contains a text box to search in name field
and two radio buttons , One to search at the beginning of the Name field and the other to search at any part of the field
I also created a button to open the search query and I wrote IIF statement as
IIf([Forms]![form name]![radio button name].[OptionValue]= -1 ;([table name].[name field]) Like "*" & [Forms]![form name]![text box name] & "*";([table name].[name field]) Like [Forms]![form name]![text box name] & "*")
but it not work correctly , Where error in IIF statement
and what The best way to create this form
I am new to access. Please help

It would help to see the complete procedure for the button, but this is what I see.

You can't refer to the field using [table name].[name field] syntax.
If the option buttons are part of a frame, you need to refer to the frame value. It will be an integer, usually 1,2,3,...
If it is not part of a frame, you would use IIf([Forms]![form name]![radio button name] = TRUE, .........

If you are trying to limit the recordset for a form that is already open, you should set a filter. If you are going to open a form and filter the recordset, use the WHERE clause of the open form command.

(And the aforementioned semicolon instead of a comma in the If() function.)