Select an item in a combobox

[Blue in Green]

Hi,

When I open a form, I want a particular record from the underlying
table to be selected in a combobox.

How can this be done?

Thanks,

Marc

[Don Leverton]

Hi Marc,

Try this:
(Example assumes a one-column combo-box containing textual data.)

*******************************************
Option Compare Database
Option Explicit
Private Sub cboLastName_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[LastName] = " & "'" & Me![cboLastName] &
"'"
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

Private Sub Form_Open(Cancel As Integer)

Me.cboLastName = "Leverton" 'Supplying the "particular record from the
underlying table" here...
Call cboLastName_AfterUpdate 'Calling the combo's AfterUpdate event from
here

End Sub

*******************************************
--
HTH,
Don
=============================
Use My*****@Telus.Net for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.

Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop

================================

"Blue in Green" <lu***@mail.com> wrote in message
news:24********************************@4ax.com...

Hi,

When I open a form, I want a particular record from the underlying
table to be selected in a combobox.

How can this be done?

Thanks,

Marc