 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2005How do I add a record from a form
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  Signature-Larry- -- > 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?! Is your form bound to the table to which you are trying to add a new record? SignatureMore info, please ... Jeff Boyce <Access MVP> > 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?! 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! > Is your form bound to the table to which you are trying to add a new record? > [quoted text clipped - 4 lines] > anyone > > give me any tips please? I thought that a form would be better, is 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! 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. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.