Form to use for a report

[cktcPeterson]

I hope I can ask this easily

I am trying to draft a template for an approval letter. I started in forms and would like users to be able to make edits if need be that will display on each record.

I also have fields that are mixed in from a table. I am able to combine all my fields but when I close the form, the info I want there all the time clears. How can I have text boxes that are editable without clearing when I close the form?

Currently, I have them as an unbound form, should I create a new table to house the info?

 

[June7]

Must be bound to field in table. So direct answer to your question is "yes".

 

[theDBguy]

I agree. Only/best way to "keep" data is to store them in a table.

 

[cktcPeterson]

Thanks! Now I since i am using two tables that are not connected in any way, I just want the Approval Table to be set in place, and my Applications table will have all the participants. How do I keep the approval table from clearing even though the info is there?

 

[June7]

Why are they not connected? User inputs should be related to a parent record somewhere. And then use a form/subform arrangement. If you want to provide db for analysis, follow instructions at bottom of my post.