T
Trial & Error
Help!
I have a form that is used to book lessons. The 3 crucial fields are "Time"
"Date" & "Request" ( Request is the actual instructor being asked for).
There are other fields on the form... but these three relate to my question.
What I am trying to do is provide a way for the user to be certain that a
specific instructor has not been requested already at that day and time.
I currently have a subform that is displaying a select query which is set to
return values linked to the date, time and request field on the parent form...
This works great once I have saved the record and I return to it... but it
will not show the data as the current form is open.
I would like to avoid having to get the user to complete the whole form, and
save it in order for this subform to update itself.
What is frustrating me is that I have 2 other subforms on the form that take
similar actions for other aspects of the registration... and the work
perfectly... they update on the fly and allow the user to always know if
there are any conflicts.
Is there a way to solve my problem using my approach?
Is there a better way?
Is there a code that would work that would simply return an error message if
a duplicate time, date & request combination was made?
If so... any help with that code would be more than apreciated.
Thanks in advance.
I have a form that is used to book lessons. The 3 crucial fields are "Time"
"Date" & "Request" ( Request is the actual instructor being asked for).
There are other fields on the form... but these three relate to my question.
What I am trying to do is provide a way for the user to be certain that a
specific instructor has not been requested already at that day and time.
I currently have a subform that is displaying a select query which is set to
return values linked to the date, time and request field on the parent form...
This works great once I have saved the record and I return to it... but it
will not show the data as the current form is open.
I would like to avoid having to get the user to complete the whole form, and
save it in order for this subform to update itself.
What is frustrating me is that I have 2 other subforms on the form that take
similar actions for other aspects of the registration... and the work
perfectly... they update on the fly and allow the user to always know if
there are any conflicts.
Is there a way to solve my problem using my approach?
Is there a better way?
Is there a code that would work that would simply return an error message if
a duplicate time, date & request combination was made?
If so... any help with that code would be more than apreciated.
Thanks in advance.