In access, I have a form that is a custom calendar, with dates along the y axis, and locations along the x axis.
I dynamically generate textboxes and fill them with the name of the person who has a certain location at a certain date.
When I rightclick on a textbox, i have a popupmenu (through the custom toolbar options). Is it possible to pass the value of the textbox i selected to the function of the popupmenu?
Or would it be better to make a custom popupmenu in vba and just use the on_right_click event? (although that would mean setting the on_right_click event for every box and it easily generates 500 boxes)
I dynamically generate textboxes and fill them with the name of the person who has a certain location at a certain date.
When I rightclick on a textbox, i have a popupmenu (through the custom toolbar options). Is it possible to pass the value of the textbox i selected to the function of the popupmenu?
Or would it be better to make a custom popupmenu in vba and just use the on_right_click event? (although that would mean setting the on_right_click event for every box and it easily generates 500 boxes)