I had a look at Cascading Combo Boxes and managed to fix this problem. I have another issue now though. I have parameters in a query as from_date and to_date and I want these to be inserted into a label in my form
I have a form which has 2 values:
Group ID
and Group Member ID
there are two tables linked to these:
tbl_Groups
tbl_GroupMember.
How can I get the group member field to only show group members from the group ID that has been inputted in the form before the group member ID.
The group member is a...
Thanks everyone for the replies! I am a beginner in all of this so I will have a read through the comments and see what is in my capabilities haha! Thanks again
I'm creating a Hotel Database and I have a form which allows users to book a room. I have ran into a problem where users can double book a room. The fields are as follows:
room_ID
customer_ID
from_date
to_date
Is there any way to check if the room is booked between these dates to not allow the...