Adding Records with a Form

[dylcon]

Hello, I was wondering if someone could help me add records to a datasheet with a form. Once I click the commandbutton 'Apply', I would like for all of the fields in the datasheet to be filled with the appropriate values from the form.

Thanks

[rzw0wr]

Pretty confused about the question, or many by the question.

Datasheet is a form. Forms are usually populated (filled) with data from a query/table.

If you are wanting to add data to a table in datasheet view the bind the table to the form.

If this is not the case then please restate your question.

Dale

[Bob Fitz]

I assume that when you say a "datasheet", that what you mean is a table. A form is usually bound to a table by setting its "Record Source" property and each control on the form is bound to the tables data by setting the "Control Source" property of each control. When used like this there is no need for an "Apply" button. Just closing the form or moving to a different record will make Access update the bound table.

[dylcon]

I would like to have it set up that the user never needs to know that the table exists. Just a form that is very easy to use.

[dylcon]

And this way, it adjusts a record within the table. I want it to add a completely new record to the table.

[rzw0wr]

Build a new form. Add a combo box with the data you want to display.

Add a few text boxes and play around a little.

We can better help you with that then.

And this way, it adjusts a record within the table.

I don't understand?

You can add new records to your table if needed.

EDIT: Per Bob's post. You should not need an Apply button.
You may need to upload you db.
Dale

[Bob Fitz]

And this way, it adjusts a record within the table. I want it to add a completely new record to the table.

Then go to a "New" record. You can make the form open at a new record if you wish.

[dylcon]

Bob, how exactly do I do that?

[Bob Fitz]

Put the following line of code in the On Open event of the form:
DoCmd.GoToRecord , , acNewRec

[dylcon]

That does not work. Can you please use code tags?

[dylcon]

Nevermind, it did work. Thanks a lot for the help. Sorry, I am so poor at this. I am not familiar with VBA in Access whatsoever.

[Missinglinq]

...I would like to have it set up that the user never needs to know that the table exists...

A good policy! End users should never have access to your Tables, and since they shouldn't have access, there's no need to even know about the Tables!

...I am not familiar with VBA in Access whatsoever...

Take heart; we were all there at one time! And your first statement, above, shows that you are on your way to learning!

Linq ;0)>

[dylcon]

Thanks for the words of encouragement, Linq. Much appreciated.