If then statement

[DavidAC]

hi,
i am struggling with getting a if then statement to work correctly. I have a DB which is set up as a many to many as it releates to vehicle hire with a start_date and end_date. what i need the system to do is to

1. confirm hire end date is > hire start date
2. hire start date for next customer of vehicle is > end date of previous customer
3. end date must be populate before new start date can be entered

i currently have the code for the first bit but am struggling with the next bit any help appreciated.

Private Sub Date_Handed_Back_AfterUpdate()
If Me.Date_Handed_Back < Me.Start_Date Then     
         MsgBox "Please enter a date greater than or equal to Hire Start Date."
         Me.Date_Handed_Back.SetFocus         
    End If

 

[jackd]

I think you need to resolve the many to many issue.
Can you describe your tables and how they relate?

To resolve Many to many use a Junction Table.

see http://www.foresightsoftware.com/AccessJunctionTables.htm

 

[DavidAC]

sorry i am using a junction table and it is within this table that the start and end dates are held.
as i said it is the if statement's i am strugglnig with.

 

[jackd]

How about posting your tables and relationships so it is clear what you are asking?
You said you had a many to many, now you say you have a junction table. I'm a bit confused, but willing to help.