Recent content by melda11

hey ajetrumpet! You are amazing :).After a few modifications, your idea actually worked for me...Thanks man.This is an amazing forum.Thank you all for your excellent input :)

Thanks again I really really appreciate this:)

Its ok I already have a copy of it sent to my email before it disappeared ..Thx..

I saw it a while ago but it seems to have disappeared..

ok this will take a while to digest but I will definitely try it and let you know of the outcome.. Thanks:)

yes that is true..I want the updated values to be displayed in the table and the form.Is this possible? I need to view an employees leave details in the form which is why I need to update the table too.Ok I hope you guys understand what Im trying to do here.

I have created calculated fields from these fields using the switch function. Forward_updated From Forward Balance_Updated From Balance and No_of_days_updated From No_of days_Due.. These caculated fields will only work if I re-enter the caculated value in the origional fields everytime I enter a...

I also entered some test data..:)

ok this is the mdb version.Unfortunately I cannot change the fields because all these fields and data in the table are straight from excel unless I create another Select query.But I think I still need to store all these fields coz we need to check first if an employee has enough vacation days...

ok here is my database.I used both vba code and queries.In my query the calculated fields works but I have to enter the Forward,Balance and No_of_Days_Due everytime I enter a new employee and the vba code fot the OnCurrent event doesnt work.The controls are still blank.Any help will be graetly...

my form is bound to a query.This query selects from a table(which has all the fields I mentioned above except for ToBeTaken) and creates a calculated field ToBeTaken.

I tried it but the controls are blank nothing is being displayed.I put the statement in the OnCurrent event like you said.

That was the first thing I did before I used queries.But when I did that in VBA code there was an error..something like you "cannot assign this to the object"..Is this because we cant update a control because there is already a value assigned to it??This is what I thought was the problem.

Is this Iff staement in the query or control source???

Thanks Il try that out...