russkie
01-19-2006, 01:23 PM
Hey,
I have userform, in one text box you when your entering new product information is a barcode slot, while punching in the barcode (or when your down with it) the box searches database to find any copies, so you know immediately when entering the barcode whether the product already exists or another one has the same barcode.
What i want to happen is when it finds a matching barcode, a button appears to give you the option to EDIT the copy it found, for the editing there is another userform. Problem is if i do Load EditingForm and Show from this button it will load the other form, cool, but if BOTH of these forms are open it causes problems.
So how can i Unload the NewProductForm and simaultanously (SP?) open the EditingForm?
I tried to have a "midway" userform where when you click on the Edit button that appears from the newproduct form it would open up an empty userform and on that empty one the "_activate()" part would unload the NewProduct and Load the EditingForm, but i get an error saying simply it CANT unload the NewProduct form...
Any Idea?
Thanks.
I have userform, in one text box you when your entering new product information is a barcode slot, while punching in the barcode (or when your down with it) the box searches database to find any copies, so you know immediately when entering the barcode whether the product already exists or another one has the same barcode.
What i want to happen is when it finds a matching barcode, a button appears to give you the option to EDIT the copy it found, for the editing there is another userform. Problem is if i do Load EditingForm and Show from this button it will load the other form, cool, but if BOTH of these forms are open it causes problems.
So how can i Unload the NewProductForm and simaultanously (SP?) open the EditingForm?
I tried to have a "midway" userform where when you click on the Edit button that appears from the newproduct form it would open up an empty userform and on that empty one the "_activate()" part would unload the NewProduct and Load the EditingForm, but i get an error saying simply it CANT unload the NewProduct form...
Any Idea?
Thanks.