How to set focus on a field list

[NC1977]

I have a form with a field list. Once the user selects from that list, he can then proceed to another form to enter additional information. I would like for it to be impossible to continue to the other form without having selected from my field list.

How can I do this??

Thank you

 

[HarleyQuinn]

How does the user proceed to the next form?

If it's by using a button then how about only enabling the button once a value has been selected from the field list?

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[NC1977]

It is a command button...Would you this in the Afterupdate property of my field list???

Thanks

 

[HarleyQuinn]

Yeah, that should work.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[nwprog]

Use the Before Update Event for the Form.

If IsNull(Me.yourselection) Then
MsgBox "Please Make a Valid Selection"
Me.Selection.GotFocus.
End If

 

[TheAceMan1]

How are ya NC1977 . . .

Try this in the command button:

[blue]   Dim Msg As String, Style As Integer, Title As String
   
   
   If Trim(Me![purple][b][i]ListboxName[/i][/b][/purple] & "") = "" Then
      Msg = "Selection required from FieldList!"
      Style = vbInformation + vbOKOnly
      Title = "No Selection Error! . . ."
      MsgBox Msg, Style, Title
      Me![purple][b][i]ListboxName[/i][/b][/purple].SetFocus
   Else
      DoCmd.OpenForm "FormName"
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886