Recent content by John Big Booty

Once again you have gone above and beyond the call. Thank you Chris. With my assistance (and to my shame) you have managed to transform a mole hill into an insurmountable mountain. So long and thanks for all the fish.

How very prescient of you :rolleyes: It was big enough for you to hijack this thread, on the basis of a site I linked to. I suspect that, that reveals a great deal about the motives behind your initial posting in this thread.

Chris I trust you will be taking this egregious error up with the Admins over at techonthenet.com

Try adding the following to your code; Me.YourControlName.SetFocus

Chris, I see nothing you have said here, that invalidates or proves the wrongness or erroneous nature of the statement that you took issue with vis a vie; The long and the short of it is that if value_if_null is omitted the value that is returned will be directly determined by the type of...

In effect proving that the method of observation/interrogation determines the result, and thus we must be dealing with quantum value ;)

In effect it does, as the type of value that is expected determines the outcome; Dim x As Variant Dim z As Variant Dim i As Integer Dim s As String z = Null x = Nz(z) s = x i = x MsgBox "x Holds " & i & " and at the same...

Are you able post a copy of your DB?

That would tend to indicate that a selection has not yet been made in the combo47. Try; Private Sub Find_Click() 'DISPLAYING RECORDS FROM MASTER DATEWISE Dim Order_combo47 As Integer Dim rs As dao.Recordset 'Test for selection in combo and stop if no selection made If IsNull(Me.Combo47) then...

To be honest Chris I'm have a hard time finding any fundamental difference in the truth of; and At the end of the day if you are looking for a string you will get a ZLS, but if your looking for an integer you get zero. Whilst your explanation may provide a fuller description of what is going...

As an a addendum to CJ_London's reply you can find out more about the Nz() function here.

Welcome to the forum. When you are working with forms and subforms the syntax required for referring to controls/objects on either the parent or child form become a little more complex. Bookmark this link for future reference, as it will help you formulate the correct reference for controls and...

There are a number of Calendars in the sample section of the forum, you may be able to bash one of those to fit your needs.

From here;

Have you tried the code in your Combo's On Change event?