How do I get user-input text to be retentive on a form??

[Timothy McG]

Need to make unbound data input fields retentive on a basic form.

Access must open, allow the user to add text and numbers in various text boxes but then EXIT and SAVE that info on the form. It will be used and then cleared later.

I tried creating bound tables & forms but they don't do what I need. Need the input text to remain there for use the next time that Access is opened.

[gershwyn]

Can you elaborate on what bound forms do not do, that you need them to? The simple answer to your question of how to make data persist in a form is, quite frankly, to make it bound.

It's possible to go the unbound route, but I strongly suspect it would be less cumbersome to use bound fields with some supporting code to accomplish what you're looking for than throw the whole thing out and reinvent the wheel. Either way, I don't really have enough information to provide any help.

[TheSmileyCoder]

From what I can guess from your post, you should be able to use a bound form, and simply set its properties to only allow the creation of new records. Set the forms DataEntry property=True to achieve that.

[Timothy McG]

Bound to what??

How it works is that Access is called from another program. A "header" is presented to the user in which he/she enters some basic information.

A report has text boxes that call the data from user entry on the "header" form.

But I want Access to open, have the user enter the needed data, and then EXIT. But still retain the user entered data on the "header" form.

I'm not an expert with this so I am using simple "build event" picks from lists of commands. VBA for Access is not my forte'.

[TheSmileyCoder]

A form bound to a table. I still fail to see why a table cannot be used to store your information.

[Timothy McG]

i tried creating just that using the wizards. But the data does get transferred to the table. I wish that I knew more about how it works. But unfortunately I don't.

If I create a table and save it. then create the a form and select all fields from the table etc, why does the user-entered data not get transferred to the fields in the new table?? Do a macro on top of all that??

[TheSmileyCoder]

If you have created your form correctly the information does get stored in the table. I suggest you read up on some basic access tutorials, before you start to even consider moving on to macros.