double booking

[hayden]

hi im very new to access
how do i once i have selected a date in the field on my form. how do i make it so that the same product cannot be double therefore dispears or cannot be selected from the drop down list for a particular date which the product already booked out for, i know i have to use a dlookup but not sure where it goes or what i do at all???

 

[HiTechCoach]

see this previous post

http://www.access-programmers.co.uk/forums/showthread.php?t=190076&highlight=clashing

 

[hayden]

yes that has helped me alot so far but they have this on that website
NoClash: ([tblEvent_1].[Start] >= [tblEvent].[End])

which i understand but how would i go about that they cannot equal each other what do i use

 

[Brianwarnock]

<> is not equal

 

[hayden]

NoClash: ([tbBooking_1].[Booking Date]<>[tbBooking].[Bookingdate])


i have now entered that and now have it working.

however in the table it puts -1 for true and 0 for false what do i add to it so i can make it say clash or no clash??

 

[The_Doc_Man]

Look at the IIF function. That should do what you want.