value on a form not being used

[bobh]

Hi All,

In AccessXP I have a form, the user selects stuff and in a hidden
unbound textbox(bxOfcCde) I create an 'In' statement like
In('1f','mf')

then on the click event of a button I run a query which uses the
string above as criteria in the Ofc_Cde field with a usual reference
on the criteria line like [Forms]![frmMainMenu]![bxOfcCde]

but it's not working, the query returns 0 records yet if I type the
same string In('1f','mf') in the criteria of Ofc_Cde directly and
run the query I get records.

What am I missing??

thanks
bobh.

[Clint Stowers]

On Oct 26, 2:51 pm, bobh <[e-mail]:

In AccessXP I have a form, the user selects stuff and in a hidden
unbound textbox(bxOfcCde) I create an 'In' statement like
In('1f','mf')

then on the click event of a button I run a query which uses the
string above as criteria in the Ofc_Cde field with a usual reference
on the criteria line like [Forms]![frmMainMenu]![bxOfcCde]

but it's not working, the query returns 0 records yet if I type the
same string In('1f','mf') in the criteria of Ofc_Cde directly and
run the query I get records.

Perhaps a Me.Refresh AfterUpdate might help.

[Salad]

bobh wrote:

Hi All,

In AccessXP I have a form, the user selects stuff and in a hidden
unbound textbox(bxOfcCde) I create an 'In' statement like
In('1f','mf')

then on the click event of a button I run a query which uses the
string above as criteria in the Ofc_Cde field with a usual reference
on the criteria line like [Forms]![frmMainMenu]![bxOfcCde]

but it's not working, the query returns 0 records yet if I type the
same string In('1f','mf') in the criteria of Ofc_Cde directly and
run the query I get records.

What am I missing??

thanks
bobh.

I don't know. I tried various methods myself. I could come up one that
works like this
Me.bxOfcCde = ",1f,mf,"
Then in the criteria
Instr([frmMainMenu]![bxOfcCde],"," & [Ofc_Cde] & ",") 0