Hello,
I have 2 tables:
Product_List
Product_ID (PK)
Product_Name
Client_ID
and
Client_List
Client_ID (PK)
Client_Name
They are linked from Client_ID in Client_List to Client_ID in
Product_List.
On my form I have 2 combo boxes, the first is unbound and simply looks
up the Client_Names from the Client_List table.
It has an after_update event of:
Private Sub Client_Name_AfterUpdate()
Product_Name.RowSource = "Select Product_Name from Product_List " _
& "where Client_ID=" & Client_Name
End Sub
CB2 (Product_Name) has a record source of Product_Name where I need it
to be stored.
Now this all appears to be working, apart from that when I pull down
on the Product_Name Combo Box the fields are all blank. Even stranger
is that the correct amount of products for that client can be seen by
the amount it highlights as you move the mouse up and down the list!
I've got the bound column set to '2' as that is the product name
column in the table (product_list)
Anyone seen this before, or am I being stupid?!
Much appreciated in advance,
Chris.