Click on the com,bo box. Slect properties.Change "Row Source Type" to
"Query\Table". Select the query for the "Row Source". Set "Bound Column" =
1. Set "Column Count" = 2. Set "Column Widths" to "0;[whatever width you
want for the combo box]"
Go to events. Check that "After Update" is set to "{Event Procedure]". Click
on the "...' button next to this item. The code window will open. Check that
the code looks something like this (where cboSelect is the name of the
combo):
Private Sub cboSelect_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
If Nz(Me.cboSelect, "") <> "" Then
rs.FindFirst "[lngMemberID] = " & Str(Nz(Me!cboSelect, 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End If
End Sub
Guy Harley
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Carl Vogt
Sent: Tuesday, 25 October 2005 10:42 PM
To: [email protected]
Subject: [ms_access] Re: Combo Box Help Problem!!
Guys,
Thanks for the input, made the Query no problem. But have a problem
with the combobox Wisser, in Access 97 there is no option to select
another query or table for the select record... is this a feature
added in 2000 or 2003??
Tried to edit the Properties of the combobox and change the source to
the query but will not work,
What do I need to change in the properties,, to make this work if
possible in 97.
Thanks again for your help..
Carl
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
