Hi
I have a sample vs 2008 vb.net winform project at http://www.infovis.biz/Test%20EMS.zip.
If you run the project you will see a form with some sample data. Use the buttons in the form’s bottom area to scroll through the records. Everything works fine. You can even change text in fields and moving away from record will save it.
Now go back into project and uncomment line 123 in frmStaff.vb ie
Me.txtRate.Value = CStr(DLookup("[Rate]", "[Rates]", "[Rate ID] = """ & txtRateID.Value.ToString & """"))
Now run the project and scroll through records. Soon you will see that information stops appearing in fields. The purpose of above line is that when user selects a Rate ID from the drop down then the system looks up the corresponding Rate Amount and fills the Rate field with it. So my question is, why is this lookup causing this problem and what is the correct way to lookup a value and assign it to a bound field without causing this problem?
Thanks
Regards
Yahya
PS: The project needs to be extracted in C:\ folder so the project ends up in C:\Test EMS folder.
Hello Yahya,
I believe that a similar question has already been answered here: http://social.msdn.microsoft.com/Forums/en-us/winformsdatacontrols/thread/23fe660b-c8a0-4058-bc2f-287d6606b8b4.
Please do not hesitate to contact us if you need any additional assistance.
I posted this question on 03-20-2008 9:00 PM. Thank you for replying three and a half years later. Better late than never.
Hello again Yahya,
Thank you for your feedback and for posting in our forums. We believe that the other community members could benefit from your thread.