Search results

HI! Arnlegp, i have done the updates but on subfrmTask, field TaskId does not get updated in subfrmComments field TaskId. Hope i have clarified my question.

HI! Arnelgp, Apologies for the confusion. Made wrong updates. I will re try and post the results.

HI! tried as you have mentioned and yes i want to link SubformComments to SubformTask after i update Task and move to update Comments and come out of the form. It does not get linked.

HI! Arnelgp, i have followed upto the code. not able to do the below linking now add Link Master Fields & Link Child Fields to subform3: Link Master Fields: [txtLink] Link Child Fields: [CommentsID] i have attached my db, if its the same understanding what you gave me the code. Thanks

HI! all i have one main form with two subforms within it. i have managed to link 2nd subform to Main form by Link Master Fields & Link Child Fields. However i am struggling to link 2nd subform to 3rd subform Any suggestions. Below are the 3 forms in my db MainForm frmVisit PK...

Thanks Arnelgp, i missed to thank you. I have marked this thread as solved.

Thank you June7 for the time and the code. this is what i wanted. works perfectly. i was struggling to find the code for long time. Thank you once again for your support

Thanks June, yes I did not see your post after edit. Will check and update you shortly

Thanks June7, can you assist me pls

HI! June7, I will try to explain the scope, hope it helps 1st part of the job is: UserA captures the below details looking at the documents in Table3 using form "frmEIOutward" to a subform "Subfrm_tbl3" which is linked to Query3 Adds: a) Entry_Date & Our_Ref one time b) BankName c)...

thanks Mark, From your data, if they SHOULD be working on RefNos 0003, but they mis-type it as RefNos 0004, your method won't catch the error. If they only need to type in the RefNos and you show them something unique, they are far more likely to catch an error. Along with RefNos user will...

Hi! Mark I am responding to your remarks I want to avoid combox for the fact that i want the user to look at the document and capture the details rather then selecting the dropdown list. There are repeat account nos with different ref_nos is also another reason to avoid combobox. Yes, the...

HI! June, Checker captures the below line in form "frm_CheckerVerify" RefNos BranchName AccountNos 0001 BRN6 1234567890123 if one of these is mis-match it should stop the user from moving forward until he rectifies the line. RefNos is unique, however...

HI! all, any help from any one on the dlookup function. I am trying to combine 3 fields validation while matching data. So far no luck. thanks

HI!, i have applied the Dlookup that you provided however it accepts even the incorrect data. Combox will not apply, since i want user to type the account nos looking at the doc and not select any drop down.

Thanks June for your response. Sure when i am making the final version will have this taken into consideration Yes probably you are right, but i only going to store the data for a particular day and then the data is deleted. The whole idea was to force the checker to check the 3 fields...

Hi! all Tried to search the net, but unable to find this. Below 3 fields which I am trying to capture. On the before update event it should match all the below 3 details for the given Entry_Date(if one of them is not matching it should not capture and a pop-up alert msg of the mis-match The...

Thankyou very much Arnelgp for your support. Yes it is working fine now thank you very much

sorry if missed any punctuation cause sending through mobile

SELECT RowNumber("SrNo",[SrNo],"EntryDate","Query1) AS IDNos FROM Table1;