Pop up list box

[chunk22]

I have a form which users enter generic details on for an incident. A field (Incident Type) when selected determines what form is opened next after a click button. I want to display a list box on the form that displays what sub Incident Types are related to the Incident Type they select on the main form, sub incident types are on the next form displayed static in the table field.

Thanks

Chunk22

 

[PHV]

Dynamically build the RowSource SQL code with the appropriate WHERE clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[chunk22]

Many thanks for the reply, i'm new to using Access and SQL could anyone help with the structure of it, or get me on the right track.

Details are:

On change event in combo box (Incident Type) to Update a seperate list box with the incident types in the RowSource of a table also called Incident Type for example

Main form incident type - Crime

Sub form incident type - Theft from Retailer;Theft from The Oracle;Theft from Vehicle;Theft of Vehicle;Graffiti;Criminal Damage;Drunk in Charge;Fraud;Other (Specify)

Thanks

chunk22