M Mikki Mikki Local time Today, 14:03 Joined Jun 11, 2008 Messages 25 May 27, 2014 #1 Good Day~ How can I search through a table and if the record on a main form has certain words it will save a note in a record on another table Any help would be greatly appreciated~mjc
Good Day~ How can I search through a table and if the record on a main form has certain words it will save a note in a record on another table Any help would be greatly appreciated~mjc
B burrina Registered User. Local time Today, 13:03 Joined May 10, 2014 Messages 972 May 27, 2014 #2 Use the DLookup function along with your criteria. Example: If DCount("*", "tblJobSalesperson" < 1 Then If DLookUp("[PaidComm]","tblJobSalesperson") = True Then Click to expand... HTH
Use the DLookup function along with your criteria. Example: If DCount("*", "tblJobSalesperson" < 1 Then If DLookUp("[PaidComm]","tblJobSalesperson") = True Then Click to expand... HTH
M Mikki Mikki Local time Today, 14:03 Joined Jun 11, 2008 Messages 25 May 29, 2014 #3 Thank you for your help. How can this look up be done on a specific ID number? Thanks again~mjc
B burrina Registered User. Local time Today, 13:03 Joined May 10, 2014 Messages 972 May 29, 2014 #4 Me.SomeField = DLookup("[SomeFieldInTable]", "SomeTable", "SomeTable=" & Me.SomePrimaryKey) Click to expand... Here is an example. HTH
Me.SomeField = DLookup("[SomeFieldInTable]", "SomeTable", "SomeTable=" & Me.SomePrimaryKey) Click to expand... Here is an example. HTH