Display old value, Enter new value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy Ward - 17 Mar 2007 01:27 GMT

I'm hoping I can even explain my problem!

I have a table of SubTasks and a table of ESLOCS. I have a query
qryLatest_SubTasks (based on the latest SubTask date) and a query
qryLatest_ESLOCS (based on the latest date the ESLOCS were entered). The
record souce for my form, frmEnter_ESLOCS, is a qrySubTasks_and_ESLOCS, that
joins qryLatest_SubTasks and qryLatest_ESLOCS. The form displays bound
fields from the query in continuous forms mode.

None of the bound fields in my form are updatable, which is fine because
when they update their ESLOCS, I do not want to change the existing ESLOC, I
want to enter a new record in the table with the current date. I have no
problem with the code to do this.

My problem is giving the user a way to enter a new ESLOC. I have tried two
different tactics. One was to include an unbound text box, txtNew_ESLOC.
Even though I can see a text box for each different line of my form, an entry
in one text box populates all the other text boxes--they are not individual.
If I make txtNew_Esloc bound to a field in my query, then it is not updatable.

Any suggestions? If you know of a resource that displays data and allows
the user to enter changes in a separate field, I would appreciate knowing
about it.

Thank you,
Judy

Reply to this Message

Damon Heron - 18 Mar 2007 23:03 GMT

It is a bit confusing. You want to add a new record to your table? If the
form based on the tables/query is not editable, you can still add a new
record at the end by using the nav buttons. Make sure the form's property
for allowadditions is true. If, on the other hand, you want the user to be
able to only edit his/her own record, then that is a different issue. You
would probably have to tie that to some UserId at log on.

Explain further

Damon

> I'm hoping I can even explain my problem!
>
[quoted text clipped - 28 lines]
> Thank you,
> Judy

Reply to this Message

Judy Ward - 19 Mar 2007 02:49 GMT

Thank you for responding. I wish I could include a screen shot of the form!
In order for a user to change the ESLOCS for the SubTasks I am displaying a
form with the SubTask ID, SubTask Description, which release the SubTask is
going to be included in, the date the SubTask data was last changed, ESLOC
for the SubTask, and the date the ESLOC was last changed. The form is in
continuous forms mode, so all of this information is displayed as one
row--and there are many rows.

I also put a text box (to enter the new ESLOC for the SubTask) and a Command
Button on the form--so they show up in each row. I have tried making the
text box an unbound control. But if the user enters 2000 in the text box for
Sub Task 1, all of the text boxes on the form (for all the Sub Tasks) are
populated with 2000. I have tried adding an extra column to the table for
the new ESLOC and making the text box a bound control, but none of the bound
controls on this form are editable.

I see what you are saying about allowing the user to enter a new record, but
the point was to allow them to stay on the same line as the existing ESLOC in
order to see and enter a new value (but still keep the record of the old
value). I'm thinking the command button is going to have to open a form that
allows the user to enter the new value (and from that I will insert a new
record in the ESLOCS table and refresh the main form to reflect the change).
This will work, but I was hoping to come up with a solution that would
ultimately allow the user to enter the new ESLOC for more than one SubTask
before clicking the Submit button.

Thank you for trying to help!
Judy

> It is a bit confusing. You want to add a new record to your table? If the
> form based on the tables/query is not editable, you can still add a new
[quoted text clipped - 39 lines]
> > Thank you,
> > Judy

Reply to this Message