Hi all,

  In my Dabase i want to give some advance option to get the work more automate ..:) .

 Now iam running an database for Fund tracking in the I would have to enter the total fund amount and the fund amount will distributed by more the two installment..

 For eg.

Fund Table :
Date
07/01/2006
21/01/2006
08/01/2006

Fund Number
F101
F102
F255

Fund Name
Maintenance
Party Expenses
Maintenance

Amount Allotted
$.1058
$.2000
$.1058

Completed

Yes / No
- do -
- do-


Entry Table Fields:

Date of Entry , Issued to ,Fund Name ,Amount Issued


I want to get the result like ..

 The Fund F101 may get completed by the 1st month or by 3rd month but i ill get the maintanance fund every month. Now wat i want is every time the fund is going to finish the complete field should automatically change to Yes .. If the field changes to Yes then the field should Locked ...

 Did u understand because the end user are not much computer knowledged...

 Please help me.. if ur not able to understand .. reply ...

thanks in advance ...
anukagni

Learn as you can..
------------------------
pap...

You should be able to set a condition somewhere to change the value of the Completed field to Yes under conditions you specify. When would you run this process? Is it determined by date, or some other action?

As to locking the records, on the On Current event of a form, you can set the condition that if Completed = True then Allow Edits = False.

You can also prevent users from viewing completed records in your data entry form by filtering for Completed = False, and then have another form for viewing completed records, or use reports instead.

HTH

mmcdonal

Please explain me in details.....



Learn as you can..
------------------------
pap...

When would you run this process? Is it determined by date, or some other action?


On Current event of form:

If Me.Completed = True Then
    Me.AllowEdits = False
Else
    Me.AllowEdits = True
End If





mmcdonal