I have been struggling with my "if statement" and my "do until end of file statement"

[TenOc]

Windows 10 Access office LTSC Professional plus 2021




I only make changes to our access program every year to so; therefore, my programming skills get rusty. I am struggling with a new task and I am sure that you can help me.


I have a form (call it form 1) which data comes from a table (call it table A). Form 1 has a number of fields but for this discussion we will call these fields STATE and CITY. These are not their real names but will make it easier to understand my problem. Employee 1 enters data into a number of the fields on form 1. Employee 2 then enters data into more fields including the field I am calling CITY and STATE. These two fields are entered using cascading combo boxes. So far everything is working well


The problem arises if employee 2 fails to enter data into these 2 fields or enters an empty string. Because of some legacy data and other complications, I cannot make these 2 fields required fields. My solution is to add a button (call it check for errors) to step through all the records in table A and locate those that have either a null value or an empty string. The last few days I have been struggling with my if statement and my do until end of file statement loop to find these errors.


I thought about posting my code here. But I recognize that it is written so amateurish that probably would be different for you to understand what I’m trying to do because I have added a number of MessageBox comments and other tools including commented out code that I have tried that did not work that it would be better if you could give me some sample code that will start me down the right track.


Any help would be welcome.

[Welshgasman]

It still gives someone something to work with. ��
Otherwise they are just guessing, and computing and guessing do not work well together?

[CJ_London]

post your code - ensure you use code tags (the # button) to preserve indentation.

Otherwise it is just guesswork since there are several ways to check for 'required'

[TenOc]

I found a simpler way, but you coding experts may not like it. I put a button that sorts the data by these 2 fields so if they do not contain the valid data they go to the top of the view list. I'm declaring this problem solved.

[Micron]

Why would you need a loop for this? If you want to return these records to the form so that you can manually fill in the missing data, filter the form based on the field(s) so that it shows records that are null and "" as well.

If you're saying you cannot design the table field to be required, you can enforce those fields to have values IF some other field(s) already has data if that would work with your process. If not, back to the original question - why the loop? You may not need it at all. Last, did you put a break point on your code and watch it execute line by line? That might reveal a problem.

[TenOc]

Why would you need a loop for this? If you want to return these records to the form so that you can manually fill in the missing data, filter the form based on the field(s) so that it shows records that are null and "" as well.

VERY good suggestion. I may try it.