If is null

D

deb

I have a form fTLNo with a subform called fWS
fTLNo has a text field called TL

Now..
On the subform fWS I have a date field called RecDate.

If TLNo on the main form is not null, I must also have the RecDate populated
on the subform.
Please help.
 
N

NetworkTrade

it seems like you did not complete what the question is about...

if fTLNo is an integer you can use >0 or otherwise Not IsNull( )

not clear when the decision is made.... on the main form - or subform....
 

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

validation help 8
If help 2
complicated if on form 3
dlookup in sub subform 2
form visible if parent has record 1
Count IIF 4
basOrderBy 1
concantinate number with decimal places 2

Top