field exists <> null in the subform?

F

Frank Dulk

How do for what do in the event when opening of the main form I, do verify
if a field exists <> null in the subform?
 
M

Michel Walsh

Hi,


If DCount("fieldName", "TableName", strCriteria) = 0 Then
... there is no record in the table that satisfies the criteria
with a not NULL value under the supplied field name.

else
...

end If



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Append Crosstab Query to Existing Table 0
How do I clear a form? 0
if a # then sum, if text leave null 2
VBA code returns no records hwenKey ID is added 14
OpenForm and Navigate to Subform Record? 1
how do I get a custom message box to open? 2
Hide subform based on value in field on subform 3

Top