I have a combobox with suppliers names, I have it so if a name you type in is not in the supplies table it opens up the "add suppliers form" You can then add a supplier. I have a comand button with a macro that add the supplies and closes the form. The problem i have is when it closes the form the original form "products form" closes also.
New at this and any help would be good.
access 2007