VBA button to transfer data in an Access Form to an Access Table

[RGM2244]

I appreciate the help in advance,

I have a Microsoft Access form that users enter information into (text boxes and option buttons) and on that form I have a button that users are able click. Here is where my issue resides; when the button is clicked I would like the information they have entered to transferred over to a specific table on Access. (I can have this data transfer over to an excel sheet if that would be easier) What would the VBA code be that could write for this button in order to make this happen?

Thank you for your time

[twinnyfo]

RGM2244,

You rform should be bound to a Table, then you won't need any code to transfer the data. This is the standard setup for any form.

[RGM2244]

twinnyfo,

Thank you for getting back so quickly. I believe my form is unbound since I have created that and as of right now there are no tables.

[RGM2244]

twinnyfo,

If I decide to create a bound form will it automatically create new entries without altering the previous entries with the simple click of the button put into the form?

[twinnyfo]

In general, yes.

The general concept is that you create the Table first. Then, you create the form, based on the fields in the Table. As you navigate to new records on the form, new records are created in the table. You can also modify any existing records in the Table by navigating to that record in the Form.

I would refer you to this link: Normalizing Databases, which will help you understand some basic concepts about databasae design, and also recommend you search the web for some good MS Access primers on building database projects.

Of course, we are always here to help and offer advice.

We especially appreciate when posters try their own methods first, and when their efforts are ineffective or unsuccessful, post their designs so they can be improved. We love to help those who are trying to expand their capabilities!