Need help in programming in ms access 2007

[ericjw316]

I am setting up a system for a friend of mine. I have 2 date fields that have to be selected from and to dates.

Below that i have a drop down list that needs to check to see if in of the items in the list are already being used between those dates.



I can upload the access file if that would help you but i am trying to find a way to get this done for her.

Please let me know if you can help.

[ranman256]

on the form pick the item in the drop box
also 2 text boxes called
txtStartDate
txtEndDate
(properties, other tab, name)


the query will then use:

where
[code] = forms!frmMyRpt!cboBox
and
[TheDate] between forms!frmMyRpt!txtStartDate and forms!frmMyRpt!txtEndDate

[pbaldy]

This may be appropriate if your items are out for a range of dates rather than a single date.

http://www.baldyweb.com/OverLap.htm