Hi,
I am trying to use macros with a button that opens a form called "Static Casting Inspection" displaying 6 fields from a table. I also have a subform in Static Casting Inspection that can be edited by the user. I need the 6 fields to be displaying a t the top, so in macros I have put multiple "where" conditions to display those 6 fields. Here is what I have typed in macros:
="[Order_Number]=" & [Order_Number] & " AND [Item_Number]=" & [Item_Number] & " AND [Pattern_Number]=" & [Pattern_Number] & " AND [Description]=" & [Description] & " AND [Customer_Name]=" & [Customer_Name] & " AND [Analysis]='" & [Analysis] & "'"
But, when I click on the button, I get this error:
If I delete Pattern_Number from the macros, I get the same error but for 'Description'. Did I type something in incorrectly, or should I be typing this in elsewhere?
thanks!