How do I add a record from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am very new to Access and I'm having a spot of bother. I have created a
form and on it a button with an "Add Record" action. When I press this, it
does not add a record in the Datasheet view. Should it? If not, could anyone
give me any tips please? I thought that a form would be better, is it?!
 
Hi Kate,

Most developers don't use datasheet view in their final product,
usually they use it as a diagnostic in getting their design going.

For adding a new record, look in Access help for the GoToRecord method
of the Docmd object. That's the code you want in your command button.

HTH
--
-Larry-
--

KateAccess said:
I am very new to Access and I'm having a spot of bother. I have created a
form and on it a button with an "Add Record" action. When I press this, it
does not add a record in the Datasheet view. Should it? If not, could anyone
give me any tips please? I thought that a form would be better, is
Click to expand...
it?!
 
No, I did do that earlier but it was just very confusing. Do I need to create
a blank form from the table and then add to it from there? For example, can I
add a combo box to the form that will show up as a column in the table? Very
new to this!
 
KateAccess said:
No, I did do that earlier but it was just very confusing. Do I need
to create a blank form from the table and then add to it from there?
For example, can I add a combo box to the form that will show up as a
column in the table? Very new to this!
Click to expand...

You build your tables first and then build forms bound to those tables
afterwards. As a quick start you can build the table structure and then select
the table in the db window and press the Auto-Form button. This will create a
form bound to your table that already contains controls bound to all your
fields. Then you just need to rearrange the layout as desired.
 
Back
Top