Open the same query into a Recorset and set the value of the combo box to
the desired field in the first row from the query.
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("query_name")
ComboBoxName = rst!FieldName
HTH,
Toby
----- Original Message -----
From: "bitschon" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, July 13, 2005 5:05 PM
Subject: [AccessDevelopers] Combo Box Default
> I am filling a combo box from a query. I want the default in the
> unclicked box to be the first row of the query.
>
> Is it possible?
>
> Thanks
> John
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
