If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
new to Access
I am just learning Access 97. I have created a form but it is taking the data
entered in entry 1 and automatically entering it in all entries. How do I change this? I would like each form to be a place for distinct, survey-gathered information. Does it have to do with how my form is linked to a table? Ideally, I would like to enter the data in the form first, and then have that information be collectively and automatically stored in the table. thank you. |
#2
|
|||
|
|||
Yes, that is the reason.
Typically, you would not enter the data and then store it like you mention. Typically you'd build a table and then base the form on that table. The form wizard will even help you build it. Creating an unbound form as you request is much more complex and will probably involve writing vb code to handle the write back to the table. Start out simple and build a form bound to a table and drag the fields you want into the form. -- Rick B "abarnes" wrote in message ... I am just learning Access 97. I have created a form but it is taking the data entered in entry 1 and automatically entering it in all entries. How do I change this? I would like each form to be a place for distinct, survey-gathered information. Does it have to do with how my form is linked to a table? Ideally, I would like to enter the data in the form first, and then have that information be collectively and automatically stored in the table. thank you. |
#3
|
|||
|
|||
Ideally, I would like to enter the data in the form first, and then
have that information be collectively and automatically stored in the table. thank you. a form does not store data, it only displays it. if your form is bound to a table (form's RecordSource property is not blank), then each record you "enter" in the form is actually being written to the table when you a) save the record in the form, b) move to another record or to a "new" record, or to a subform within the main form, or c) close the form. if your form is not bound to a table (form's RecordSource property is blank), then you only have the current data available to edit or save to a table. you can't enter multiple records in an unbound form, unless you save the current data to a table before starting a "new record". and you lose the current data when the form closes, again unless you save the data into a table. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ambiguous Name Error | pm | Using Forms | 10 | June 5th, 2005 09:19 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |