combo box problem

[murlen]

I'll try to explain this as best as i can for what I need

I have two tables, lets call them 'objects' and 'values'

in the objects table we have;

peter
paul
mary

in the values table we have;

car
bike
truck
horse
dog
cat
beaver


What i would like to do is, in a form have two combo boxes
one for objects and one for values.
here is the tricky part, when i select 'peter' from the objects box
i only want to see values associated with peter (car, horse, beaver)
and the same when i select 'paul', i only want to see the values associated with paul (car, bike, dog).

How do you go about doing something like this?

thanks

 

[WayneRyan]

Murlen,

In the AfterUpdate on your first combo put:

Me.Combo2.Rowsource = "Select Value " & _
"From YourTable " & _
"Where TheName = '" & Me.Combo1 & "'"

Wayne

 

[murlen]

thanks, I'll give it a try