defining a field from a form in SQL
Posted on 2012-12-28
I have a form, [EOS Ranking], which has a command button to call for another form. I set the record based on the filter criteria [item_number]
I had to change my subform and it now it too includes a field [item_number] as well so, where this string worked before, it no longer does.
DoCmd.OpenForm "sfrm_sales_xref_data", WhereCondition:="Item_Number = '" & [ITEM_NUMBER] & "'"
I think I need to define that [item_number] is coming from my primary form [EOS Ranking]
How would I rewrite my script?