form info does not go to table

[janm]

I'm new at this, and all the other posts are above my head, and I only need something very simple. All I want to do is create a mailing list to print envelopes using Word Mail Merge. Only need: Name, Address, CityStateZip - just 3 columns in the table (city, state, zip all on the same line). I think the table is set up correctly with the columns, but I don't want to type directly onto the table. I want to type 1 single record at a time on a form (ie: once i type a record and click enter, i want it to go to the table and a new blank form to appear. I tried to do the form wizard, but the records I type into the form won't appear on the table. Pls help! Thanks! Jan

[June7]

The form is bound to table and textboxes are bound to fields of the form RecordSource?

Record entry/edit on bound form is committed to table when form closes, move to another record, or run code.

What is the code for the Enter button?

BTW, I deleted your other thread that duplicates this topic.

[janm]

in the meantime i found that if i clicked the refresh button on the table, the form info came up on the table. So do you always have to click "refresh" on the table to be able to see the new records?

[janm]

I always click "enter" after I've typed a new record in the form, so that the form fields are empty for the next entry

[June7]

Don't understand. Do you have the table open as well as the form that is bound to the table?

What 'enter' are you clicking? Are you using the form navigation bar?

[janm]

yes, well as soon as I create the form, it opens over the table as a new "tab" (looks like a tab on an old-fashioned folder). So both are open, but I can click on whichever "tab" to get to the table or the form. So on the form, I type my info into the three boxes I've made- using the keyboard key called tab. (safter I've typed in the info into all three boxes, I press my keyboard key "enter", and the boxes on the form are now empty, i'm assuming because the record went to the table and the empty form boxes are waiting for me to type in new information. But if I look on my table, there's no new record. But if i click refresh on the table menu at the top, the record(s) I typed on the form finally show up on the table. I'm just trying to confirm whether I always have to click refresh to get the info to finally show up on the table. Or am I doing something wrong? Thanks

[janm]

clarification: I use the tab key on my keyboard between typing into each of the three boxes, then the enter key on my keyboard after I've finished that record and am ready to type the next one

[June7]

Yes, if you have the table open, it must be refreshed to display the new record. Why do you have table open? Why not interact with data only through form? Are you the only user of this db?

The form is 'blank' because you have moved to a 'NEW' record. Is the form DataEntry property set to Yes?

[janm]

I'm the only one who uses this database. Ok, so after I've created the form from the table, I should close the table? Also, where do i find the form DataEntry property?

[June7]

What do you mean by 'created the form from the table'. You mean the form already exists and you open it? How are you opening the form?

On the Data tab of the Properties dialog.

[janm]

I open access, then click "blank database". Then I name my 3 columns: Name, Address, City/state/zip.Then I save it with a name ("mailing 8-8-12 for example). Then I click create .... form .... blank form. The field list opens on the right side of the new window. I click on the correct table in the menu. The fields I created in the table come up. I drag the 3 field I want to use over to the blank form. Then click "form views" and start typing in the boxes. AFter I've finished one address, as I said I press enter on the keyboard and type the next one. etc. I want to use the database I create in Word for a mail merge to address envelopes. Is there a better way?

[June7]

You should only be doing "click blank database" once. This creates a database that can later be opened and worked with again. Create database, create the objects (tables, queries, forms, reports), enter data. When finished for this work session, close the db. Tomorrow you can open it again and everything you built is available. However, the table does not need to be open. Just open the form and enter more data, run reports.

If you want each mailing in its own database, no need to build everything again. Make copy of 'template' database with a new name. However, a major concept of relational database is to avoid duplication and that includes duplicate copies of the same db structure. Put all data in one db file and filter records to work with only those needed for current session.

[janm]

OK I see! Thank you so much for your patience and help!!!!