I have a form that has like 20 buttons (each button is related to a bed), like a scheme of where are the beds in a inn.
I want to know if it is possible when I click in button 1 to show me the results of the query. The query would be to show the time that the bed is occupied (so it will have like some enter dates and the end dates). The problem is not how to do the query.
The question is if I have to do 20 querys (1 for each bed) or can the query be related to all the buttons someway. If I open this form and click in button 2 (bed 2) it will show me the results for bed 2, and then if I go back and click in button 3 (bed 3) it will show me the results for bed 3.
Is this possible? Thanks in advance!
I want to know if it is possible when I click in button 1 to show me the results of the query. The query would be to show the time that the bed is occupied (so it will have like some enter dates and the end dates). The problem is not how to do the query.
The question is if I have to do 20 querys (1 for each bed) or can the query be related to all the buttons someway. If I open this form and click in button 2 (bed 2) it will show me the results for bed 2, and then if I go back and click in button 3 (bed 3) it will show me the results for bed 3.
Is this possible? Thanks in advance!