Create a table from an Unbound form

[WLC]

May not be using the correct terminology here. I have a form that currently does not have a RecordSource. From this form, I want to create a table called "ICEA" with the following fields (which would be entered from the form): OperatingDay, Hour_Ending, Import, Export, and Net.

Can this be done with a SELECT statement or does it have to be done through VBA?

Any help would be greatly appreciated!

WLC

 

[jdraw]

A couple of questions:

How would you prevent creating a new table every time you filled in the form???
Why not create the table, since you know the fields involved, and use the form for "data Entry"??

Also you would not store the calculated field Net (as I read your post) in a table. Net can be calculated via a query when needed.

Maybe I'm missing your intend approach.

 

[WLC]

I do want to create a new table every time. Net is not a calculated field. These are all fields that would be hand keyed on the data entry form and populate the table.

For more information. I will have a macro that will take the table once the data entry is complete and append it to a master table then delete the table. Hence the reason I'm creating a new table every time.

I'm sure there's a better way to do this but this seems the most simplistic to me.

 

[jdraw]

Yes, as AccessBlaster and I have suggested -- create the table; then use your form for data entry. No need for Master table and session/daily tables.

What exactly is Net?

 

[WLC]

I could have to potentially create it hundreds of times a day. I will eventually have a few more users in the database and I don't want to have them coming to me everytime they want to enter data. I suppose I should have mentioned that sooner.

Net is just a number that is NOT a plus or minus of something. I could have called the field anything.