Controlling List Box

B

Beginner Bill

I have created two databases one is category and one is category_item. How do I set up the second data field list box in the form (item) to only display the items for the category that was previously selected ?
 
P

Perry

You'll have to hook the rowsource property of the category_item listbox
up to the category listbox.
Have it respond to the (for instance) AfterUpdate event of the category
listbox

Simple example:
Private Sub category_AfterUpdate()
Me.category_item.Rowsource = _
"select * from category_item where category = " & me.category
End Sub

Krgrds,
Perry

Beginner Bill said:
I have created two databases one is category and one is category_item. How
Click to expand...
do I set up the second data field list box in the form (item) to only
display the items for the category that was previously selected ?
 
Top