filtering 2 expressions

[smoke]

hi as of right now im filtering my subform with
WAREHOUSE_listview.Form.RecordSource = "SELECT * from master_inventory WHERE ([tblinvpn] = frminvitem & [tblinvgr_flag] = frmwhsegroup)"

can soemone tell me whats wrong with my part that says :

[tblinvpn] = frminvitem & [tblinvgr_flag] = frmwhsegroup

? i know its probably wrong, was just curious if anyone knew the solution to this, thanks

 

[WayneRyan]

smoke,

WAREHOUSE_listview.Form.RecordSource = "SELECT * " & _
                                       "From master_inventory " & _
                                       "WHERE tblinvpn      = " & frminvitem & " And " & _
                                       "      tblinvgr_flag = " & frmwhsegroup

This assumes that frminvitem and frmwhsegroup are:

1) Numeric - otherwise you'll need "punctuation"
2) The names of valid controls on the form - (they look suspicious with "frm")


Wayne