Search results

Thank you, the message box is showing me the first record only as you mention in your post, I want the result to be taken from the line in focus so line two should be 10>50 not 1>10 as per the first line. Do you know how I can achieve this?

Here is the DB :)

Sorry Paul I amended it to this: Private Sub Pick_Ship_Quantity_GotFocus() Dim strSQL As String strSQL = Forms![Order Entry Form]![Backlog Orders subform].Form![Quantity] > Forms![Order Entry Form]![Backlog Orders subform].Form![Current Stock] Debug.Print strSQL If Me.Dirty = True Then...

Thanks for the tip Paul, I added this in and the result was FALSE, does this mean it is working? I'm not if it makes a difference but the field Pick_Ship_Quantity is on a sub form in the main form and the fields I am looking at our on a separate subform in the same main form, they are all...

Nothing happens, the message box doesn't appear but there appears to be no errors in my code.

Hi All I am trying to run a message box using an If statement which is activated in a subform however the If statement is looking at a field in a separate subform, both subforms are within a main form. The vba I have at the moment is below: Private Sub Pick_Ship_Quantity_GotFocus()...

Hello All I have been meaning to join this site for a while as some of the posts have helped me massively :) Thank you and keep up the good work. Fellow lover of Access!