If Function....struggling

[Richio]

I am struggling getting the exact code for my If function, any help would be appreciated.....

I have a purchase order form linked to a main customer table - so every order has to have an associated customer.

The Customer No on the order is a combo box linked to the Customer table with a "Not in List" message box.

Each Customer has a current status eg Active,Complete,Delayed and only want to allow orders to be raised depending on the status.

I am trying to write an If statement (in after update) along the lines of

If table.CustomerNo."the customer no entered" status = "Complete"or "Delayed" then MsgBox "the status of this customer does not allow orders to be made"

But seem to be getting in a mess with my brackets and dots etc

I am sure this is simple to an expert

Many thanks

 

[Ally]

Can you post your exact code please?

 

[Richio]

Thanks Pat

although I entered the code and it accepted it, it did not seem to work - it did however get my train of thought going and I entered the criteria "active" in the combos rowsource query so it only picks up the active jobs and amended the message box on this.

seems to do what I wanted it to. I will see how I get on

Learning all the time!!