Problems with Form data entry

[GarthRodgers]

Hey

I'm designing a booking system and on my booking form I have an ActiveX Calendar control. The user selects the date on the calendar, which is then transferred into a text box, whose control source is the date field in my booking table.

My problem is that if the user changes his/her mind about the date chosen, choosing another date causes the original date to be updated into the booking table. Is there a way to stop this from happening?

Thanks

[garethfx]

OK forgive me for being a little slow here.

If you are booking something like a room then the option to change the original booking date and update this original entry to the secondary is vital.

Why do you want to keep a date that could be of no use unless you need that date for a specific reason, which in the case you put forward does not call for this.

Keeping a date that could be a punch error of that the customer feels is redundant is not really beneficial

Why are you keeping this , can you enlighten us please??

Gareth

[ADezii]

Hey

I'm designing a booking system and on my booking form I have an ActiveX Calendar control. The user selects the date on the calendar, which is then transferred into a text box, whose control source is the date field in my booking table.

My problem is that if the user changes his/her mind about the date chosen, choosing another date causes the original date to be updated into the booking table. Is there a way to stop this from happening?

Thanks

Not unless you want to make the Bookings Table a Child Table of the Main Table (1 to Many) and maintain seperate Records for each Booking. This way, the changed Booking Date would be a seperate entry in the Bookings Table. I really do not see much of a need for this unless you wish to maintain some sort of history for the client.

[GarthRodgers]

Sorry, I wasn't too clear.

The text box is there because it forms the criteria for a query which displays all available times for a certain day (to avoid double bookings). I tried to use the Calendar control in the criteria but, as it is ActiveX control, apparently I can't use it. So for the query to work, it is essential (so far as I can see) for the text box to be there.

And I do want to keep a record of all past bookings. The system is actually for booking music lessons and a required feature is that previous bookings (and hence attendance) can be monitored. The problem is that if the user is making a booking, but then changes his/her mind, the bookings table is still updated with the date that they first chose.

I'm kind of new to Access, so forgive me if I'm not being clear ;)

Hope this helps

[ADezii]

Sorry, I wasn't too clear.

The text box is there because it forms the criteria for a query which displays all available times for a certain day (to avoid double bookings). I tried to use the Calendar control in the criteria but, as it is ActiveX control, apparently I can't use it. So for the query to work, it is essential (so far as I can see) for the text box to be there.

And I do want to keep a record of all past bookings. The system is actually for booking music lessons and a required feature is that previous bookings (and hence attendance) can be monitored. The problem is that if the user is making a booking, but then changes his/her mind, the bookings table is still updated with the date that they first chose.

I'm kind of new to Access, so forgive me if I'm not being clear ;)

Hope this helps

You can use the ActiveX Calendar to specify Date Criteria and here is demo code to show you how:

Dim strMySQL As String
 
'Calendar Control is named ActiveXCtl1
strMySQL = "Select * From tblEmployee Where [BirthDate] = #" & _
                    Me![ActiveXCtl1].Value & "#"
Me.RecordSource = strMySQL