Two databases ("Nederland.fil" and "Alpen.fil") linked by Relational will stop when I use a macro loop if a keyword of one of the databases is missing or misspelled. Sometimes I want to copy a field from one database to the other. For that purpose I use a loop, but when a keyword is missing the loop stops and a message appears. In that case that record should be skipped and proceed with the next one. See example below.
Is that possible?
for i = 1 to 1500
Perhaps is then a statement in first line of your macro as:
on error resume next
for you a simple solution in this case.
However, If understand this well macro runs in a situation of a relational search.
I hope this will work in every case and hope you have no trouble with 's Gravenhage and/or Driebergen-Rijsenburg...
I think your error will be raised because the edit command cannot run: there are no records to edit in some situations?
(please add always errormessages!!)
Then it is also an option to check first before an edit command if there is a record to edit.
Before EditRecord you need this:
If Records.Count > 0 then
Then after SaveRecord :
However, you need the line 1+2 to move to the line direct after Activate "Alpen".