Jumat, 08 Januari 2016

Re: [MS_AccessPros] Re: Dependent combo boxes



You REALLY need to include the previous messages.  When you reply on the web, you MUST click the Show Message History link in the bottom of the reply box.  It's very difficult to remember what we've been talking about when you don't do that.  I've copied and pasted some of the replies below.

You need to set the Row Source for cmbCarNumber to a query that returns both the Car Number and whatever it is you want to display.  If Car Number is in the first column, set Bound Column to 1 to make that the value of the combo box.

But keep in mind that your query for the second combo is filtering on Car Name:

WHERE (((tblCars.CarName)=[Forms]![frmCars]![cmbCarNumber].[Value]))

Are you sure you want to return a number or a name?  What is the field layout of the two tables, and how are the tables related?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)

On Jan 7, 2016, at 11:23 PM, bburke@swiftaz.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


I'm not sure how to set up the cmbCarNumber so that its Bound Col. is the Car Number.



Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (19)



Tidak ada komentar:

Posting Komentar