Access 2010: continuous forms - what am typing on one row is showing on remaining row(s)

Hi EE,

With Access 2010/Continuous forms:

Is there a way to only modify the row that I typed into, without Access placing it in rest of rows on the continuous form?

Please see screen shots below. Uploaded a test MDB with the continous form.

tx for your help, sandra



1) I  typed into first row only

screen shot1
2) The second row is showing the value
screen shot 2
3) The table behind the scenes only updated the 1st row which is good....
screen shot 32015-06-02-EE-ARG-Jun-ClearingHouse-Veri
mytfeinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mytfeinAuthor Commented:
The reason the fields are named Field_1, Field_2 etc and not more meaningful names is bec the table is generated
off a text file that is imported into the Access mdb.  The file does not come with a header row.

Below is documentation as fyi

tx, sandra
2015-06-02-DV-ProgrammingandTestingGuide
PatHartmanCommented:
Are you sure that the control you are typing into is bound?  Access can keep only one value for any unbound control and so that would be seen on every row.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mytfeinAuthor Commented:
Hi Pat,

Thx so much for writing,

You are right the txtBox is unbound.

Just wanted user to type in a value, and the after update event massages it and places it in another form field that ** is bound**, essentially updating the record with the massaged value


row:
Me.txtStudentName              Me.txtMatricTerm                           Me.txtMatricDate

User would enter into Me.txtMatricTerm (unbound)

and place the revised value into:
                                        Me.txtMatricDate (bound)


Should I create a bogus field in the table, and bind Me.txtMatricTerm to get around this problem?

tx, sandra
mytfeinAuthor Commented:
Just some extra info:

It's possible for students not to supply their SSN for privacy reasons.

So this no ssn students will not successfully join to another table that DOES have the matric term.

So I want to create a screen that shows the no SSN students, and the user should type in the info manually.

The table will be output to a text file to send to another organization.

Our system carries the Matric info as a semester code   for ex: 201410, 201420, 201430

The receiving organization wants a date, so that's why I massage the Matric Term that the user types in.

tx! sandra
mytfeinAuthor Commented:
Hi Pat,

Was trying a few diff ideas that did not work and then found this:

http://www.experts-exchange.com/articles/6692/Overcoming-unbound-continuous-forms-limitations-by-staging-data.html

will create a temporary staging table to edit, and then apply the updates to the "main" table

tx for your help,
sandra
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.