If your form is actually named Form Name (with a space in the name) then
your query 1 should be something like this:
SELECT tblAuto.Automobile FROM tblAuto WHERE tblAuto.Type =
Forms![Form Name]!cbxCombo1;
If your form is named something else, then replace FormName with the
actual form name.
Good luck -
Mattias
From: tiger, on 3/3/2006 12:47 AM:
[Quoted Text] > Hi,
>
> I have two combo box on a form and I was trying to use the top combo box to
> determine the content of the 2nd combo box. i.e if the top combo box content
> is Car and Truck. If the user select Car, then the content of the second
> combo box will be list of Cars type in table and if the
> user selects Truck the content of the second combo box will be Truck in
> table.
>
> But the problem is that using the data/table/query/comboBoxes I provided
> below, When I run it I am getting a small window Title "Enter Parameter
> Value -Forms!FormName!cbxCombo1", I will like to get rid of this, and just
> let the second comboBox be populated with entering a value into the window.
>
> 2nd Question - If I change the choice of the 1st ComboBox, how can I get the
> 2nd ComboBox to reflect this.?
>
> I have a table like this below...
>
> tblAuto:
> Automobile Type
> C240 Car
> LS430 Car
> F150 Truck
> Ram Truck
> Tundra Truck
> GeoPrizm Car
> Audi A6 Car
>
> and I have two ComboBox on a Form name: - cbxCombo1, cbxCombo2
>
> In cbxCombo1 I have the following...
>
> Code:-
> Private Sub cbxCombo1_Afterupdate
> Me!cbxCombo2.Requery
> End Sub
>
> Property:-
> RowSourceType = Table/Query
> RowSource = Category
>
> Category is a Query see below...
> SELECT DISTINCT tblAuto.Type FROM tblAuto;
>
> For cbxCombo2 I have the following...
> Property:-
> RowSourceType - Table/Query
> RowSource - Query1
>
> Query1 is....
> SELECT tblAuto.Automobile FROM tblAuto WHERE tblAuto.Type =
> Forms!FormName!cbxCombo1;
>
> Thanks
> Tiger
|