Combo box value enable or disable

[Raveen1609]

Hi. I have a scenario like below in my Event booking access form.

Following are the fields in the form. Date, EventID, EventName, cost.

I have 2 values, (Event1 & Event2) in Field EventName as ComboBox. When a customer book Event1 for the day, then I want the Event2 to be disabled for the same date. And next customers should be allowed to book only Event1. The same goes for Event2. (If the 1st customer book Event2, event1 should be disabled and rest of the customers are only allowed to book event2 for the date. I kindly request a solution for this scenario, VBA code or anyother options. Thanks

[Gicu]

I assume your combo is based on a table listing the events to choose from (lets say tblEventList) and you have another scheduling table listing the customer ids, event id (from the first table) and event date, lets name it tblEventSchedule. You need to modify the row source of the combo by joining in the scheduling table and adding to the criteria row to only show the EventID and EventName Where dCount("*","tblEventSchedule","EventDate=#" & Forms!frmYourForm!EventDate & "#")>0; save this as a query named qrySelectedEventForSelectedDate or something similar. And finally in the Enter or GotFocus event of the combo have:

if dCount("*","qrySelectedEventForSelectedDate")>0
    Me.cboEventList.RowSource="qrySelectedEventForSelectedDate" 'first event already selected
Else
   Me.cboEventList.RowSource="tblEventList" 'no selection yet
End If

Cheers,

[CJ_London]

to answer your question we need to see the table structure and relationships that relate to your question plus the rowsource of your combo.

Would also help to see some example data and the outcome you require from that example data since your description is not clear. You seem to be saying you can only run one event on any given day and whoever is the first customer to book either event1 or event2 for a particular day decides which event occurs on that day.

Also not clear - are you providing available dates for either event 1 or event 2, or can a customer choose a date at random in the past or future any day of the week or weekend? (appreciate in the past is unlikely, but not specified)

And is there a limit on how many customers can attend an event

[Raveen1609]

thanks very mcuh

You are absolutely right on the 2nd paragraph

This is an itemtable with eventname, eventid. The row source is from Eventname. The relationship is itemid with itemID in bookingdetails table where the Bookingdate field is there along with customername etc..

Customer can select any date at random, for future only. No limit for customers attendance.