Filtering stuff

[Xcarnate]

Not sure what type of post this is, sry if its in the wrong area...
I'm new to access and i get stuck on lots of stuff .My current problem is as follows:

Each item is received Daily, Weekly, Fortnightly or Monthly.
A customer can choose to have it delivered Daily, Weekly, Fortnightly or Monthly.

I need to apply a filter or validation rule, or something so that the customer cannot chose to have it delivered Daily, if it is only received by the newsagents monthly.

I tried Shop Received Frequency = Customer Delivery Frequency, but that was too restrictive. I still want it so a customer can select any frequencies higher than the delivery, if possible.

I played with the idea of converting the Daily, Weekly, Fortnightly or Monthly values into numbers, and filtering them like that, then converting the numbers back into Text, but that seemed like an unnecessarily complex and inefficient idea.

So, is there a way to selectively filter text values?

 

[Rob.Mills]

If the user is selecting the delivery type from a combobox, set this procedure up in the combobox's Before Update event:

Private Sub ComboBoxName_BeforeUpdate(Cancel As Integer)

Dim strValue As String

strValue=Me![Name of box where received info is].Value

If strValue="Monthly" Then
MsgBox "Type a message here you want to tell the user.", VbOkOnly
Cancel=True
me!ComboBoxName.Undo
End If

End Sub