G
Guest
I have a macro that sorts through records. I need this macro to continue through the required records if there is information missing...Basically the macros looks to a field and if the information is not in the field the macro stops and I have to manually fix the problem and rerun the macro. I need the macro to check if the information is there and if not I need it to go to another field and and set the record to an inactive record (via checkbox) and continue to the next record....This is what I have come up with so far which obviously is not working....I am by no means an expert but I think I may be on the right track...If anyone could offer and suggestions it would be most appreciated....Here is what I have for now...
IIf ((IsNull(Family Size), GoToControl (Active), SetControlDefault, RecordsGoToNext)
I know this is not right but may give you a better idea of what I am trying to accomplish....Any feedback again would be greatly appreaciated....Thank you for your time....
IIf ((IsNull(Family Size), GoToControl (Active), SetControlDefault, RecordsGoToNext)
I know this is not right but may give you a better idea of what I am trying to accomplish....Any feedback again would be greatly appreaciated....Thank you for your time....