I have a database that would be used by multiple users over LAN. I have a form with some customers on it that order the same products weekly. Next to each customer on that form there is a Command Button that is pressed to place the order. When that button is pressed a new form opens up with just the product that particular customer orders. The problem is that I can have only one of those forms opened at the time. By pressing the button next to different customer i would like to have a new instance of the form open with the second customers product. I could have several forms and use VBA to check if one of them is opened then open another similar form, this however does not seem to be very elegant and I hoping there is a more appropriate solution.
Thanks in advance!