Form Log only Displays Live Record

[penbeacho]

Hello,



I am new to the access world and I am having what seems to me to be a very basic problem. Yet no matter how I try to record the record, The record table only shows the live data in the form, and doesn't skip to a new record. I used the form wizard and the standard default buttons. This form for some reason is larger than the attachment size allowed in the forum. This seem like I am missing something very simple yet I have been battling with this on and off for about a week. Hope someone can help me out.

[ranman256]

Yes, that what forms do is show live data in the table.
If you want the form to open to ADD new records, call it thus:

docmd.OpenForm "frmMyData",,,,acFormAdd

if you ONLY want it to add data, set the form property in the DATA tab , DATAENTRY = YES