Saving Forms and Reports.

[Mjz]

Hello.


I am relatively new to Access. The problem i am trying to solve is in my Forms i have a certain Text box1 which has a certain formula that depends on another Textbox2, from which i input a certain value. So if i input a value into Textbox 2 and generate a report the values that are in the report are what i desire. But if i were ever to go back and search for that certain form (just to look up some type of data) since the value in Textbox2 is user inputted, the value in Textbox1 gets erased and not saved. Essentially i would like a way to save the Report and/or form such that i can search it at a later time without value getting erased. I am clearly not an expert, and perhaps i am thinking about this all wrong. I appreciate any input. Thank you for your time and patience.

[Homegrownandy]

you could output the report as PDF.

What are you tying to achieve with your database?

[Mjz]

Okay, i actually have done that. The reason i would like to save the Reports/Forms in Access is due to being able to quickly search a keyword for example in the future that the form/report contains just for a quick reference, as opposed to going through all of my PDFs individually.

[Homegrownandy]

Okay, but what is the purpose of the database? It's very rare people come to this forum and have a normalised structure right away, before looking how to retrieve the data we need to see how you store it.

Any information regarding your project will help.

[Mjz]

Ok so essentially, i have a list of tables, and a list of queries. I have 1 form which takes certain data from certain tables as well as from certain queries(which stores the data from certain tables in a specific way). The form has certain equations that take data from a table and calculates it in a certain way to output a number. I have a report that takes info from the form and outputs it in a easy to understand way (from which i have generated the PDFs). So that is generally what i have, if its easier to understand i will be more specific, i have a table which has certain information about a Fuse, i then have another 2 tables which has information about currents along a line (Max current table and a Min current Table). I then have queries which just takes a couple of certain columns of the Fuse table and 2 other Fuse date tables with information, just to sort it the way i want. My form then essentially generates a bunch of information relevant to a certain fuse when a value is put into Textbox 2 of the Form. I would just like a way be able to enter a keyword from a form and bring up that respective form with the keyword without it erasing the data that was calculated when i inputted the value into Textbox 2. I hope that helps. Thank you.

[Homegrownandy]

calculated date is never and should never be saved. That way its always correct. If a variable changes, it will calculate accordingly. So.. don't seek to find the result of the calculation. you should seek to find the variables that give you the result.

are these variables saved?

[Mjz]

Ok but the variables that give the result will change for every form. So for example, my form has A B and C, variable A is inputted(not saved) and outputs B and C, but variable A will be different for every fuse which will give different B and C's. I would like to search for example B or C and get the orignal form (with or without variable A). Once inputted, can variable A be saved perhaps in a different textbox such that B and C will not erase if i go and search B or C at a future date?

[Homegrownandy]

is it possible to zip your DB and attach it here? click go advanced in the post options then manage attachments.

Its hard to answer without seeing.