1 Record Missed

[sajarac]

Hi there, I have been trying to figure out this issue, but I can not get a right solution.

In my table, I have 574 records, I can see those in my form and in the main table. I have a query without any filter and I have 573 records, I am going mental with this record.

Could someone point me in the right direction to get this record back?

Thanks in advance

Regards

 

[sajarac]

Thank you very much for your prompt reply, you turn the light, problem solved, the issue was one of the tables has a dropdown values and it was empty.

Almost going mental.

Thanks again.

Regards

 

[Mark_]

one of the tables has a dropdown values and it was empty.

If you are doing a lookup at table level you will want to rethink how you are doing this. Lookups at the table level make it far more difficult for you, the programmer, to make sure what is really in your tables.

You will find that having the code for lookups at the form level works far better as it is much easier to customize to a given form AND allows you to tell what is really in your tables.