Sorry 4 the delayed response.
Saw the sample posted by @burina & loved it. It's a real beauty.
Have not thought about ComboBox presently, though it is what is giving me a problem currently.
Currently, I have deviated a little bit, as I decided to familiarize myself a little bit with simple forms & VBA.
Am attaching the db & would request inputs :
What I am looking to do is ( If I am not wrong, it's called Cascading Combo Boxes ) :
When I select a value in IndID_FK dropdown in the Form; the ProdID_FK should be populated with Values relevant to the Selected IndID_FK.
It works fine to some extent. However, when I select a value in the ProdID_FK dropdown, it gives me a error message :
Code:
Error Message :
The current field must match the join key '?' in the table tha serves as the 'one' side of one-to-many relationship.
Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table
One of those days, seem to be banging my head against a wall.
Can I request a look at the db & let me know at what stage I am committing a conceptual blunder ?
Thanks