Can one button Save & Open a New Form?

[Nate74]

I finally have my quote generation form running. You enter a few variables into text boxes, select two things from combo boxes and several text boxes autopopulate with calculated values.



My next step is to add a button to this form (Form1) that will take the current values of many of these boxes and put them into a second form. The second form is meant to be in a layout similar to our current quote format and won't show some of the customer specific (proprietary) information from Form1. I have the second form all set up with the links back to the Form1, but unless I hit CTRL+S on the first form, the second form opens with the wrong information.

Is there a way to make one button on Form1 save all the information AND then open up the second form?

Thanks.

[orange]

You may find this article of interest in designing your database
http://www.rogersaccesslibrary.com/forum/uploads/5/12-Steps_to_Better_Databases.zip

[Nate74]

Ummm... OK. Informative, but not helpful for what I'm trying to do now. I don't anticipate being an Access developer. I just need this beta version to work well enough to present to my bosses to secure budget to hire somebody to develop this thing fully. SO in this instance, I really just want a fish today, not to learn to fish for a lifetime.

[orange]

Then why not use something like powerpoint. Make few pretty slides, if it's only a concept.

Good luck with your project.

[Nate74]

It may come to that. But the first form is pretty slick, as it's pulling data from our actual materials library and our actual customer files. My thought was if I let the VPs mess with the interface a bit and actually see real information populating it, they'd be more inclined to a) believe what I want to do is possible and b) go along with it. After fighting my way through understanding of DLookUp for 2 days, I'm not retreating to powerpoint.

[orange]

Great! Forms are sort of a window into Tables. Table design and relationships are key to getting info in and out.

If you want to post a version of what you have - no confidential info - and a clear statement or a before and after picture of what you want, I'll take a look.

Have you looked at the Openargs for a form; and you can OPen the 2nd form by clicking a button

[Nate74]

Thanks!

I'll do my best to describe where I'm at and where I'm hoping to go. I apologize if I don't use the correct terms for things... I literally started this project 2 days ago and hadn't used Access for about 10 years...

In this database, I have three tables. Two are material specific (tblAlloyData & tblAlloyPricing), one is Customer specific (tblCustomerData).

The first form allows the user to select the Alloy to be used from a ComboBox that references the primary key of tblAlloyData. Then they put in key dimensions for the part so that an autocalculate can determine the volume of the component. This is shown in a text box. Another calculation occurs where the volume is multiplied by the density from tblAlloyData. This too is in a text box. Then that weight is multiplied by the $/lb of the alloy that comes from tblAlloyPricing.

We now have an estimate of what the RFQ is actually worth and it's shown on the form in a nice red box.

The second part of this first form allows the user to select the customer from a second ComboBox. There are several customer variables that then autopopulate (DLookUp) some boxes from tblCustomerData.

The goal is to take a look at the Customer, their order history, payment history etc. and then look at the estimated value of this particular RFQ and decide if we want to quote or not.

So if they "pass" the test, I want to have a button on that first form that will open a second form that will be the actually summary quotation (or maybe a report), that will have the customer's name, the alloy, the part description and the pricing (from the first form) along with some standard stuff like our company name, address, standard terms, etc.

Longer term (or maybe I need to do this now), if the quote does get generated, I'd like to store it in a table. I wasn't going to tackle that for this demo version, but if it's needed I certainly can.

Besides geeking out a bit on all this I'm realizing the more I learn about Access, the better suited I'll be to manage this project if it gets approved