Listbox - only one item

[mpnorris]

I have a list box on my form which brings back the results of a query. The list box will only show one number. Is there a way to automatically highlight that number so that it does not have to be clicked on?

I am then using that data in another calculation.

The only reason I am doing a list box is because I can't figure another way to bring in the result of the query.

Any help is greatly appreciated.

Thanks.

 

[drctx]

you could assign a variable using DLookup:
quoteloc = DLookup("Location", "Users", "[UserNames] = '" & fWin2KUserName & "'")

or if it's a complicated query you could open a recordset and assign a value like this:

Dim db As Database, rs As Recordset, locked As Variant

Set db = CurrentDb()
Set rs = db.OpenRecordset("qryPartforLocked")
locked = rs("Locked")

 

[GingerR]

what's your query (sql) string?
what's the rowsource of the list box?
what's the "other" calculation that you're using this result for?
when is the list box filled? Are you clicking a button or something?