I am completely new to subforms in Access 2007.
I created a main parent table. Fields ID (PK); Assessment No.
I then created a form on that table.
I created a risk phrase table table. Fields ID (PK); Risk Phrase; Assessment No.
I opened the form and then craeted a subform based on my risk phrase table.
It all seemed to work ok.
I decided that it would be good to have a dropdown option in the subform so that I always chose items from the risk table (i.e. limited to the options only in the risk phrase table.
So, in the subform design view, I right clicked on the control 'risk phrase' and used the option 'change to - combo box'.
All seemed ok until I started to populate the database. Then I realised the dropdown option was growing. For instance, instead of being only 5 options to choose from, the same options were appearing over and over, mirroring what I was adding to each record.
What I want is to use a dropdown list that stays as originally written - e.g. just 5 options.
Can anyone point me in the direction of a good example database that I can look at, that utilises dropdown selections. Hopefully by looking at an example I might understand where I have gone wrong.
Many Thanks
Ron
