Search results

no thats my next question its service next due which is a calculated field called DateDue but this expression will not work :confused: Msgbox DMax("[datedue]","[PlantServiceTbl]") as it not in my table its a calculated field :confused: cheers shane

ok.. its now saying the expression you have entered is a invalid syntax it highlights Dmax Msgbox DMax("[ServiceDate]","[PlantServiceTbl]", "[serviceid]= " & [PlantServiceTbl]) cheers shane

hi right this is what I have tried but doesn't seem to be working DMax("[ServiceDate]","[PlantServiceTbl]","([serviceid]= " & [PlantServiceTbl] & ")") see what you think cheers shane

hi here's a sample database I can't understand why it always takes the first record and transfer it but the focus is set to the last record which I want it to transfer very weird I thought it would transfer they last record date cheers shane can any one see a problem cheers...

it defo taking the first record it doesnt matter what one i click on and close always take first record :(

hi i have now found problem on close it takes the value from the first entered record and adds it to the serviceduedate but i want it to take the last record value and add it to service date if this make sence cheers shane

vbainet worked you Legend!!!!! thanks again shane

Hi The servicedatedue is on a subform called "plantitemtbl subform "its main form is called "frmplant" It is the receiver Thanks Shane

hi right I have put this code in my PlantServiceTbl subform on unload event to update my PlantItemTbl subform service due text box Me.Datedue = [Forms]![frmplant]![Plantitemtbl subform] = ServiceDueDate still with no success :banghead::banghead::banghead: I have sample to show what going...

mate I wouldnt know were to start my vba knowledge is little to done normally stick to macros thanks for help tho shane

hi Gina!! Can you help show me the light in this thread when you have minute pretty please with a cherry on top ! http://www.access-programmers.co.uk/forums/showthread.php?t=266532 Shane

hi right I have tried the link you supplied still can't get it to work I wonder if there a easier way take the value from service date text box which is bound from the plantservice sub form then do this calutation DateAdd("m",[Forms]![frmplant]![PlantItemTbl...

no just the record that the user opens form by clicking the command button add service cheers shane

here some picture that might help get your head round test pic one is where I calculate the value test pic two is where I show the datedue value test pic three is where I want the date due value to get entered servicedatedue thanks again shane

right done as you said now I get compile error method or data member not found little more info I have changed "add to "datedue" this is a calculated field it generates its value by taking a value from a text box call months e.g if 12months it will see the service date and add...

right I have tried Forms!FormName![add] = [Forms]![PlantItemTbl subform]![ServiceDueDate] I get error can't find reference run time error 2450 to plantitemtbl subform thanks shane

hi vbaInet yes that is how i open frmpopupPlantService I want update values on plantitem tbl subform from frmpopupPlantService when form is closed cheers shane

hi all right I have form called frmplant on open I select plant type from the combo box then there is a sub form called plantitem tbl subform this show's the plant under that type on a continuous form so the user enters the plant information then they have command button to open...

thanks JBH works Great cheers shane

Gina can you have a look at my thread when you got some time http://www.access-programmers.co.uk/forums/showthread.php?p=1360381#post1360381 thanks :) shane