Forum has changed-where are all the category selections?
I have program that uses a “master” form to select a customer. From that master form, the user (among other things), selects and opens Pricing Forms where he enters detailed data to determine a final price for the selected object for that particular customer Id. Each Pricing Form is for a different type object. It is opened from the master form using vba modules. The master form always remains open.
When the user finishes pricing an object, then wants to price another type object for the same customer, he closes the pricing form which takes him back to the master form. He then selects another object pricing form and enters needed data.
I would like the user to be able to move from one pricing form to another for the same customer without using the master form.
I put a button on one of the pricing forms to open another pricing form. The code closes the active pricing form, them calls the same module used by the master form to open the new pricing form. The new pricing form opens OK, but I get a popup that says “Enter parameter value” and shows “Forms!F_JibPrice!break2” and a place to enter values. JibPrice is the form just closed and JibBreak2 is an expression (not a field) on that form.
If I click the popup’s Cancel or if I enter numbers in the provided blank, the popup closes and I get another identical popup. I repeat procedure on new popup and new form is useable. If I click OK for both popups, I get another two identical popups with message “Object Invalid-No longer Set”. Once rid of popups, the new pricing form functions as designed.
This is puzzling. The code used when I close the first form, then click the button on the master form to open the other pricing form is the identical code used when open one pricing form from another. Yet, one procedure works fine, the other gives me the parameter value popups. I see other items in this forum with similar hassles with “Parameter Value”, but none quite fit this situation.
Any help much appreciated.