Having trouble with a subform Null or Not

[Jon123]

So I have a subform that tracks delays there can be many delays for every main record. Users will start a delay and others will close them or complete them by entering the completed date / time. So before the save or unload
on the main form I want to check the subform for any delays that are not complete. If the HoursDelay is Null on any delays entered for this main record
then it would be incomplete. For some reason I can't catch it. Any idea's??

If IsNull(Forms![Frm-mainformname]![subfromname].[HoursDelay] <> "") Then

 

[maw230]

Try something like:

If Len(Forms![Frm-mainformname]![subfromname].[HoursDelay] & vbNullString) = 0 Then

 

[Jon123]

I was trying that and its funny sometimes it works sometimes it doesn't.
But I can't pinpoint why

 

[maw230]

Have you tried to requery the subform before you check for nulls?

 

[Jon123]

No I have not I will do that right now.

 

[Jon123]

I do not believe its doing the requery

 Forms![Frm-mainform]![frm-subform].Requery

Right?

 

[maw230]

I always test form references like that by inserting some code that I know for certain should be triggering. Where is your requery code located?

This has helped me a lot:
http://access.mvps.org/access/forms/frm0031.htm

 

[jdraw]

Jon,

Please give us 5-6 lines of what the database is about. What is a delay?Why do different users have access to correct/complete records that were started by others?
Consider this sort of logic - you have a number of records in different statuses; you have a number of users to review adjust "delay records"; Count the number of records to be completed/reviewed ; divide by the number of users and allocate specific records to specific users for vetting/completion.

Letting anyone change any record is chaos -- you have tp put some order in the process. So, allocate records to specific people. And make sure they only have access to their own records.

Good luck.

 

[Jon123]

with a Dcount query works like a champ.

If DCount(" * ", "Qry-Check for Delays") <> 0 Then