USE BUTTON TO REVIEW PREVIOUS ENTRIES

[kentwoodjean]

We have a program that is used by multiple employees on a shared drive. By use of a Dos command, the form used by the emps is set up on their hard dirve. They enter information and go to the next "new" form through out the day. With this set up, they are unable to view previous forms that have become part of the database housed in the shared drive. I have now added a completion date text box to their form and I want to place a button on the form that will allow them to view previous forms, and access the one they need to make the completion date entry in. I only want them to have permission to edit/add to the one field "completion Date".

In looking at all the options available for buttons, none that I have tried appear to work. How do I do this?

 

[KenReay]

Hi

I think you have several problem here.

You do not explain how the form is set so that usrs may only add new records, but it is presumambly by setting the allow edits, allow deltions properties of the form to false, and the addnew property to true. This puts the form in a permenant state of 'addnew'. So you button will (among other things) have to amend these properties to allow you to edit an existing record.

Once having 'switched' the form into edit mode you will need a method to switch it back to 'insert' mode

when in 'add' mode you need all fields (columns) on the form to be enabled for input, but when the form is in edit mode, only the completion date control should be enabled, this can be achieved using the .enabled and .locked properties of the controls

I think you will find the cxreate button wizard covers most of the things you need to do ie:

Add new record

Move next/previuos.first/last record

Find a record

But firsdt I think you need to think and plan how this new functionality will behave in terms of user usage

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK