Hi guys i am new to this and i searched everywhere to find the right solution to this.
I created a button that opens up a new form and the where statement is this ="[CustRef_ID]=" & [Customer_ID] ,however i dont mind showing no records but the problem is that now when the user tries to add a record it wont let them because when you go to create a new record it blanks out the filtered reference. Basically i think i need to remove the ability to add a new record. and then create a button that will create a new record. but how do i get the new record to have the CustRef_ID in it.