Saving data from form to table

[huskies]

Here is my problem! I have two seperate forms set up that I want to enter data into a single table.. This table has colums for both forms.. I have the froms linked to the table and data goes to the first line of the table but if I submit a second form it just takes the place of the original data o the first line of the table.. I need the data to populate thoughout the entire table.. Thoughts? Thanks!

 

[dkinley]

Errr ... Use just one form?

Or, don't repeat the control for the field you don't want replaced in the second form.

-dK

 

[huskies]

have to use two forms.. Just dont know why it saves the data only on the first line of that table.. even if i only submit data from the one form it still cancels out the data on the first row

 

[dkinley]

You mean the first record? Or the the first field of a record?

If the first record of a table, then you have to cycle through the remaining records in order to access the first field of the remaining records.

If you want the first field of all records to 'automatically' be updated with something you put in the first field of the form, then you might want to look into an update query.

Here's a link that might provide some insight ...

http://www.techonthenet.com/access/index.php

-dK

 

[dkinley]

have to use two forms.. Just dont know why it saves the data only on the first line of that table.. even if i only submit data from the one form it still cancels out the data on the first row

In general, a form will only present the current record of the table the form is bound to. You have to progress the form to the next record in order to access the data in it.

This is why only the 'first row' of a table is being changed. Look at the bottom left-hand corner of the form. You should see a rectangular box that allows the navigation of the records contained in the table. Click the right arrow to move forward a record, or, 'second row', and so on and so forth. The little asterisked arrow is to create a new record, or it will add 'another row' and make it the 'last row'.

-dK

 

[huskies]

right but I don't want to have to do that, is the only way to use the update query? Or is there another way maybe to be able to get this data on separate rows!

 

[huskies]

Figured it out! Needed to change my form property to Data Entry: Yes.. Thank you for your help DK

 

[dkinley]

If I understand your need correctly, then the answer is no, there is no easier (or expedient) way than an update query.

Again, you are talking different records. Records can exist independantly of each other, hence you have to perform some action in order to bridge across them. A form is an interface that presents table data in a user-friendly fashion. This is not a limitation, but an enhancement, since a database is not a spreadsheet - so technically, there are no 'rows'.

I guess in a spreadsheet you would enter it into the first row and drag the corner down to fill in the entire column. In essence, that is what an update query does for you but the enhancement is that it can occur automatically without you having to click and drag and you have the capability of selecting specific records in which to do this with based on criteria.

-dK

 

[dkinley]

Figured it out! Needed to change my form property to Data Entry: Yes.. Thank you for your help DK

Errr .. okay. Great!

Guessed I totally missed the issue. My apologies.

-dK