Search results

An easy way would be to put the following code in the Form's On Current event; Me.NameFirstControl.SetFocus

Try; Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.ImpactTicket) Then MsgBox "Please fill in the Impact Ticket." Me.ImpactTicket.SetFocus Cancel = True End If End Sub You require the Cancel = True to stop the Update process otherwise it just continues merrily on...

Sorry just noticed your question :o Simply copy the code you currently have. Select the form events, you can tell you have this as there will be a small black square in the junction between the vertical and horizontal rulers at the top left hand corner of the design window; Select Event...

Try this link

Your data on the face of things would appear to be rather de-normalised :eek: With a more normalised data structure this task should become a whole lot more straight forward.

So for example; Between Nz([Forms]![SearchForm]![YearField], 1900) And Nz([Forms]![SearchForm]![YearField], 3000)

You could use the Nz() to return a value below you expected minimum for the From criteria and above the expected maximum for the to criteria.

Perhaps the discussion and sample here will help you.

Glad you got it sorted :)

If you form is Unbound, as you say, that means that the data entered into the form needs to be committed to the underlying tables using either VBA code or macro actions. However if the form is bound to a table then data entered into it should be automagically saved to the table. Also check the...

Given the potential for inconstancy in the data entry of addresses you are going to have your work cut out for you. Start by having a look at the various Text Manipulation function available here. This link may give you a start point, also try searching this forum on the subject of splitting...

Which form are we talking about :confused:

How are you committing the data to your underlying tables?

Welcome to the forum. Is your form bound or unbound? If it is bound, what is the Allow Additions property set to?

Perhaps the discussion here will give you the answer you are looking for.

Sorry my bad :o

Perhaps this article will give you some pointers.

You have set the AllowAdditions property to False, but at no point allowed for it to be re-set to True, Try; Private Sub Form_Current() If Me.RecordsetClone.RecordCount >= 3 Then Me.AllowAdditions = False Else Me.AllowAdditions = True End If End Sub

Perhaps the sample here will give you some pointers. I believe it is doing pretty much what you are after.

Welcome to the forum. You could use the DLookup() function to populate your second field. Another method would be to use a combo to select items in your first filed, then populate the second filed from the combo using; = Me.ComboName.Column(x) Where x represents the column number that holds...