Search results

Hi, Thanks for your help earlier. I am faced with 2 issues now: 1. When I save the data in the table through the form, the row of data that was entered earlier gets overwritten and replaced with the new one. The requirement is to add new rows and only update the existing rows. 2. The...

Thanks a lot !!! your post was immensely helpful !

Thank you !!!! Thank you !!!! Thank you !!! verrrrrrrrry much !!!! You're a life saver man !!!

Hi, I have a added a code in the After Update event of a textbox which I need to call to display value in another textbox. This is what I have entered in the After Update event: ------------------------------------ Private Sub Text41_AfterUpdate() [Me].[Text45] = DLookup("DIVISION_CD"...

I did not get you, what did you mean by 'actually show what your expression currently looks like' ? Yes, the tables are being pulled from SQL server.

Please find the screenshot attached. Also, the name of the form is REGISTER_VESSEL. However, I noticed one thing that the DIVISION table is not linked to the REGISTER_VESSEL form. Could that be the problem ? Pls also find the access file attached.

That is not a crosspost....if you look carefully this post is different in nature to what I asked yesterday. This is just like going off-topic when the main and genuine issue still stands.

Thanks, I have tried doing what you mentioned but I am getting the same error- #Name? Also, Text41 is the name generated by access and I did not change it. Would that make a difference ? I am stuck with issue for sometime now and dont know what to do with this. Could you help me please ?

Thanks, but I am not able to undertand you, do you mean this code shouldnt be there in the Control Source property of Text45: ------------------------------------------- =DLookUp("[DIVISION_CD]","dbo_DIVISION","[LINE_CD] = ' " & [Me].[Text41] & " ' ") -------------------------------------------...

Thanks David, I tried what you mentioned but I now get an error - #Name? I have entered this code in the textbox of the DIVISION CODE(Textbox45): --------------------------------------- =DLookUp("[DIVISION_CD]","dbo_DIVISION","[LINE_CD] = ' " & [Me].[Text41] & " ' ")...

Hi, I am trying to autopopulate a textbox2 from another textbox1 and using this code for the same: =DLookUp("DIVISION_CD","dbo_DIVISION","[Text41]") The problem is the above code works for only the first time. When I change the value in textbox1 the next time, the value in textbox2 does not...