Access Form Combo Box

Page 1 of 1

0 Replies - 603 Views - Last Post: 05 November 2008 - 12:46 PM Rate Topic: -----

#1 IpcTrain  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 05-November 08

Access Form Combo Box

Posted 05 November 2008 - 12:46 PM

From an Access switchboard; when form opens or loads; the ClientID combo field should display the first record in the list. The list is sorted in ascending order.

The combo field is a concatenated field:
SELECT tblClient.ClientID, IIf(IsNull([Company]),[LastName] & ", " & [FirstName],[Company]) AS Name
FROM tblClient
ORDER BY IIf(IsNull([Company]),[LastName] & ", " & [FirstName],[Company]);

This code does not place the focus at the top of the combo list:
Private Sub Form_Load()
cmbclientid.BOF
End Sub

Thanks...

Is This A Good Question/Topic? 0
  • +

Page 1 of 1