Search results

Dear Guys; i need your help, I have a form name navigation panel and show the total number of record in field Text0 and Text12. so i want on click of button it copy the value of specified field above (Text0 and Text12) in Statistics Table . i tried the code below but it work if there is a...

i tried but the same error

its big size cant attache. the form name:Patient_Information subform name: pt data1 sub subform = diligent Filed name in subform : Printed_By so when the user update any date in sub subform then wanna field in subform : Printed_By get updated with [Forms]!Patient_Information.Form.STFF_ID2.

i modified the code as Forms![Patient_Information].[pt data1].Form!Printed_By = [Forms]!Patient_Information.Form.STFF_ID2 but got the same error message

Hi guys; I need your help please, I have a form with sub and subform , when used update the field in sub subform , i wanna the value in subform to get updated , i tried this code : [Forms]![Patient_Information].Form.[pt data1].Printed_By = [Forms]!Patient_Information.Form.STFF_ID2 but got...

thanks alot its OK now. i appreciate your help

Dear Sir; it work good but when i close the form and open again the does not work just show me the end message " Updated" how to solve this

thanks alot successfully solved am rally appreciating your help .

the code work well but one issue why the linked ID of man form become blank see picture

please find the attached picture

i used but same error i get

my idea is that whenever the use click on the button then subform will be updated automatically with the value present in the form for example if user click 10 time then the subform will be updated 10 time with value present in NO_of_cycle.

i work for 1st record the i got error message , and it leave a blank row and add the data in second row. please see the image

Dear sir; this is working but the issue is that it automatically add new record but what if the current record is blank (null) wanna update it and if not go to new record please se attached form for error i get

please find attached picture

its working if there previous record ( ID in subform not null) but if ID is null then id dose not paste in same row.

i tried but it dose not paste and remain in new record Private Sub Command1608_Click() On Error GoTo new_Err Me.[cycle subform].SetFocus 'sets the focus to sfrm_Each_Book_subform If Not IsNull(ID) Then DoCmd.RunCommand acCmdRecordsGoToNew Me.[cycle subform].Form.Cycle1 =...

FOR Record keeping to present the number in the report

hi Guys need help i have a form and subform , when user click on button then record in form will paste in subform but have issue if the ID is null then paste immediately or if ID not null then go to new record. i tried this code but dose not work Private Sub Command1608_Click() On Error...

thank you dear i have solved the issue as i will filter by start date only will serve the purpose