If IsNull checking two text boxes on two different sub-forms

[RainLover]

VBA suggested that using a query would allow you to sort the Data.

A Table is unreliable as far as sort order is concerned.

 

[RainLover]

I always use a Query as a Recordsource for a Form or report. Well almost always. Sometimes I use SQL Statements in Code.

But then I always test as I go when developing. eg I decompile wheras you feel as though this is not necessary.

You allowed a couple of things to slip through your naming conventions. What else are you going to allow to just slip through.

I am still tring to understand why you want information about a Form that is not opened. How can this help without opening the form. Why do you not wait until the Form is open then use the on current event.

 

[andy_dyer]

I always use a Query as a Recordsource for a Form or report. Well almost always. Sometimes I use SQL Statements in Code.

But then I always test as I go when developing. eg I decompile wheras you feel as though this is not necessary.

You allowed a couple of things to slip through your naming conventions. What else are you going to allow to just slip through.

I am still tring to understand why you want information about a Form that is not opened. How can this help without opening the form. Why do you not wait until the Form is open then use the on current event.

It's not that I think that these things are unnecessary it's just that I didn't know what they were and how to do them... I normally do compile to check for any obvious errors but because I'd copied some forms over to this small database for posting I'd not recompiled after removing some fields that weren't needed for the example...

With regard to my form I have my exchange rate field looking up the correct exchange rate for a given currency and date without this information input in other subforms (all still linked to the single main table) then the exchange rate cannot calculate correctly - I never know whether to use the onopen oncurrent or onload event - so I just experiment until I get something that appears to work. The fact remains the fields should be completed prior to trying to open the finance subform...

Does that in anyway explain what I've done and not done?

 

[RainLover]

Does that in anyway explain what I've done and not done?

Everyone has a reason for doing things incorrectly. The reason is not important. What is important is helping you to do things right. Even if that require a little step backward. As you develop these little things cause bigger and bigger problems So why not fix now. If you want to continue the way you are then that is up to you and fine by me.

I said my bit so I will move on.