Couple of Questions

[cade1980]

Hi to everybody I have a couple of questions ,

1. I have a field where I only want A or B to be allowed now i have used code to validate in the form of In ('A','B') but it allows lowercase letters to be input and I would like just uppercase and if possible without the need for using a combo box
2. I have form validation that stops an end time being before the start time but this does not stop somebody being able book another time that starts during the first therefore double booking now lets say I had a game and I booked it out for 30/04/2012 from 10:00am until 14:00pm how would i stop the same game being booked out during this time



Thanks

[June7]

1. Use code in AfterUpdate event of textbox to convert entry to uppercase.
Me.textboxname = UCase(Me.textboxname)

2. Have code in BeforeUpdate event to check for conflicting booking record and if found cancel the entry and inform user with message box.

[cade1980]

Thanks for the quick response for 1 i just went with the look-up and limited the choices to mine, it seemed the easier option especially as I have not used much coding, but I am thinking for 2 I will have to look at the way you say as I don't think any simple validation will cut it.