populating the page based on item chosen

[steveuk]

Hi guys



Sorry im a newb here and im trying to find a solution to a issue i have with my form/database.

ive looked on google and couldnt find information as im not sure the right wording so its taking me to different pages and things im looking for.

basically what i am try to do is have specfic text boxes or items appear on the form depending on the combobox item you have chosen.

For Example

Combobox

CAR
CAKE RECEIPE
CLOTHING

if car is chosen 2 text boxes appear example car manufacturer, Car name. If Cake recipe is chosen a larger text box appears, if Clothing is chosen another combo box appears and gives you more options.

I know its probs basic to most but i would appreciate some help if possible.

Cheers

[June7]

Set the Visible property of the dependent controls to No. Then code in combobox AfterUpdate event, something like:

Me.tbxCar1.Visible = Me.cbx1 = "Car"
Me.tbxCar2.Visible = Me.cbx1 = "Car"
Me.tbxCake.Visible = Me.cbx1 = "Cake Recipe"
Me.cbxClothing.Visible = Me.cbx1 = "Clothing"

[steveuk]

Hi June7 thanks for your swift reply

I was using the above as Examples just to check on my form i have a table called "slattype" and the values which populate the combobox "combo18" are "Number" "Destination" Num & Destination" "Other"

So using your above code

Me.tbxNumber1.Visible = Me.combo18 = "Number"
Me.tbxDestination1.Visible = Me.combo18 = "Destination"
Me.tbxvia1.Visible = Me.combo18 = "Destination"
Me.tbxNumber1.Visible = Me.combo18 = "Num & Destination"
Me.tbxDestination1.Visible = Me.combo18 = "Num & Desination"
Me.tbxvia1.Visible = Me.combo18 = "Num & Desination"
Me.tbxOther1.Visible = Me.combo18 = "Other"

Hopefully how i have written that, if Number is selected a box appears for just a number. Destination shows 2 boxes one for Destination and one for via, Num and Destination shows 3 boxes one for num one for dest and one for via, and Other shows one box.

Hopefully ive grasped that right.

Basically imagine your trying to order bus information. Number is the Service number you fill in, Destination shows a box for the location where its going with a second box for a via. Num and Des shows all 3 boxes and Other just one box for anything else.

Cheers bud hope you get what im trying
EDIT: didnt work so my codes slightly wrong somewhere

[June7]

What is the sql of combo18 RowSource?

[steveuk]

Here ive attached so you can see, ive gotta clean the start up page, but its the Slattype one i need the help with

Cheers for your help mate

[June7]

The RowSource is just referencing the table. The first field in table is the ID field which is column 1 in the combobox. The combobox is bound to column 1. That means the value of the combobox is the ID, not Slats value.

Options:

1. set the code to test for the ID value

2. set code to reference Slats column of combobox: Me.combo18.Column(1)

3. change the RowSource to pull only the Slats field.