Forms Problem

  • Thread starter Thread starter ice
  • Start date Start date
I

ice

Hi Everyone

This is my first message

I am having a problem with forms in access

i have two combo boxes the results in the second combo boxes depends on

what is selected in the first.

The problem i am having is, the item you selected is being carried over

into the second combo box.

for example

If the list in the first combo box is something like this

PHP
CSS
Java
Shellscripting
Html

So you would choose a language then in the second combo box it would be

populated with titles of books based on that language.

so if i selected PHP

The results would be like this (in the second combo box):
PHP
Book1
Book2
Book3

So it is carrying over the selected item from the first combo box is
there any way to stop this from happening??

Thanx for any help
 
On the AfterUpdate Event of First Combo box, write the code like that

SecondCombo.RowSource = "Sql statement"
SecondCombo.ReQuery

The SQL Statment can be a query or parametrized query that get the result
basis on the first combo box value
 
Sorry problem solved, i had some bad data sorted where it was not meant
to be, so my code was working all this time. lol o well
 
Back
Top