J JHB Have been here a while Local time Today, 07:06 Joined Jun 17, 2012 Messages 7,732 Aug 8, 2016 #21 It seems to go nowhere, you delete data, tables etc. then the forms isn't open correct. So how can we help you, do you think a sample database would help you?
It seems to go nowhere, you delete data, tables etc. then the forms isn't open correct. So how can we help you, do you think a sample database would help you?
J JHB Have been here a while Local time Today, 07:06 Joined Jun 17, 2012 Messages 7,732 Aug 8, 2016 #22 Try the below lines: Code: DoCmd.OpenForm "Home", , , "Customer=" & Me.aa & " AND [Shipped]=-1" or DoCmd.OpenForm "Home", , , "Customer=" & Me.aa & " AND [Shipped]=0"
Try the below lines: Code: DoCmd.OpenForm "Home", , , "Customer=" & Me.aa & " AND [Shipped]=-1" or DoCmd.OpenForm "Home", , , "Customer=" & Me.aa & " AND [Shipped]=0"
K Khushalay Registered User. Local time Yesterday, 22:06 Joined Apr 16, 2016 Messages 180 Aug 10, 2016 #23 Thanks alot, It worked
