Search results

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...

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...