cross check against look-up table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
in our office, unfortunately, I seem to be the only one concerned with
consistency between datasets. We have a table with street names that we can
draw from but people don't always use it (and I don't have control over every
database to "Limit to List"). Is there any way to cross check between
tables. It would be nice to be able to set up a query that works somewhat
like spell check, is that possible. I have tried to avoid SQL as long as
possible and I am not real familiar all the functions.
I looked into loading the street names into custom.dic but all they seem to
offer is a single entry form. Any help would be greatly appreciated.
 
You can try the dlookup to see if the street name exist in the table,
On the after update event of the field in the form you can write the code

If isnull(dlookup("Street Name", "Street Table", "Street Name = '" &
me.StreetName & "'")) then
msgbox " Street does not exist"
Else
msgbox "Street exist"
End if

I hope that what you are looking for.
You can't do that just using SQL.
 
Back
Top