I am in the process of converting from ms access. I have a code that looks at a database on txtreportedby.text_LostFoc
us event. It querys a db call Advisories. The way the select statement is: SELECT Name from Advisory WHERE Name = '" +txtreportedby.text+ "'. If the name is in the db, it will popup form "Advisories". The DLOOKUP I have from access is:
'If no match is found do nothing
If IsNull(DLookup("[name]", "Advisories", "[name]='" & Me![txtReportedBy] & "'")) Then
Any help would be greatly appreciated as I have quite a few DLOOKUP I am having to convert. I have searched around and there is no place out there that comes close to the experts on here. So thanks in advance!! Also I am using VB.NET not C++.