Auto display a Value (1 Viewer)

[mike60smart]

Hi Everyone

I have a Combobox named "cboDriver" has the following :-

Row Source:

SELECT DriverT.DriverID, [DriverFName] & " " & [DriverLName] AS Driver, DriverT.TruckNumber, DriverT.TrailerNumber FROM DriverT;

with an after

And an Update Event as follows:-

    sSource = "SELECT qryForExpired.DriverID, qryForExpired.LoadID, qryForExpired.ShipRecvCD " & _
      "FROM qryForExpired " & "WHERE [DriverID] = " & Me.cboDriver

   Me.cboBanned.RowSource = sSource

My 2nd Combobox named "cboBanned" with a:-

Row Source:

SELECT qryForExpired.DriverID, qryForExpired.LoadID, qryForExpired.ShipRecvCD FROM qryForExpired WHERE [DriverID] = 2

displays the correct values when a Record is selected.

Is it possible to automatically display the first value in the dropdown list without having to select a value?

Any help appreciated.

 

[cheekybuddha]

Is this linked to this thread on UA, Mike ?

 

[mike60smart]

Is this linked to this thread on UA, Mike ?

Is this linked to this thread on UA, Mike ?

Hi David

Yes my apologies I got more interested in the Rugby England v France and forgot to make a reference to the other post.

 

[cheekybuddha]

Painful (for us English!)