Recent content by Leebarley

Hi Ranman256, Managed to get this working with a slight tweak to the code (see below), excellent does exactly what was needed. Many thanks for your help.:) Private Sub Delivery_Date_BeforeUpdate(Cancel As Integer) Dim vValidDays As String Dim vDow As String vValidDays = CustomerID.Column(2)...

Hi Ranman256, Many thanks for responding so quickly.I have copied and pasted your code into the BEFOREUPDATE event in the DATE field in the form but this does not seem do anything when I run the form? I have looked at the coding and think I understand what it is relating too but cannot see...

Hi All, I am trying to create a database where customers have specific delivery days ie Mon, Wed, Fri or Tue, Thur depending on the customer. I have setup a customer table which shows which days this customer has deliveries and created another table for order entry which pulls the customer...