Carl- It helps if you include the entire thread in your replies so that someone (like me) who wants to jump in late can see the entire problem. I've pasted your original posts below.
What is the Record Source of your form? If it a query, please post the SQL - open the query in Design view, choose SQL View from the View menu, and paste the text you see (SELECT ... FROM ...). What is the Row Source of the combo box (again, the SQL if it is a query), and are you still seeing the same name(s) multiple times? This can be solved with one more exchange... John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Carl Vogt Sent: Wednesday, October 26, 2005 2:18 PM To: ms_access@yahoogroups.com Subject: [ms_access] Re: Combo Box Help Problem!! Guy, Sorry but this old Geeeser is a bit brain dead, Tried several variations, get the choices to appear on the form but the VB blows up when I try to click on the name, just having trouble of where to add the names for the query and fields to your VB statements.. The Query is "Names", the field with the composit name is "expName", the common linked field in both the "Races" (the table the form comes from) and the "Names" query is "MemberID" the combobox is "combo33" How do I plug these into the statement for the "MemberRaces" form. Again sorry I am so dense.. thanks again Carl 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 From: "Carl Vogt" <[EMAIL PROTECTED]> Date: Tue Oct 25, 2005 8:11 am Subject: 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 From: "Carl Vogt" <[EMAIL PROTECTED]> Date: Mon Oct 24, 2005 11:18 am Subject: Combo Box Help I have a club database, there is a Table and Form for Race results. I want a combo box to select and display race results for a member based on the last name first name. The problem is the combo box shows each of the last names Many Many times.. Tried to connect the combo Box selection to the members tablem (only lists each name once) without any sucess. How do you use a different table in a combo box to select rows to view in a form?? Hope this is clear... Thanks for the help, you guys were great on my last question.. Carl ------------------------ 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/
