Recent content by robinski

I have a query which is supposed to collect an ID from an open form. The form IS open. In this example the ID No is 191 and the result shows an upside down ? in the eight reords and an additional square in the first record Here is the SQL: SELECT [Forms]![frmFixedData]![LastNumber] AS ID...

I have this code in the Lost Focus Event to prevent a null value. If IsNull(Me.Analysis) Then MsgBox "Need To enter Data Here in this field",, "Need Data" Me.Analysis.SetFocus End If After OK is clicked the focus goes to the Analysis field but moves straight on to the next field in the tab...

I am still getting the cursor go to the [Analysis] field but then go straight to the next field in the tab list. Thanks, robinski

I have now added your suggested code to the application and it works as I had hoped with the exception that I would prefer the focus to return to the original field. Thanks robinski

Thanks guys, this is my first query. Is it usual to acknowledge the help? Is it OK to send an email direct with "Thank You" ? I do understand you do not wany questions direct. Cheers, Robinski

Greetings, I have a text field which is a required field. It is marked 'required' in the table properties. This causes the error message to appear when attempting to leave the record. I need the error message to appear when leaving the field. I have read the 'help' explanation but cannot...