Scrolling through Sub-Form Records

[wscwt01]

Hi folks,
I have a Combo Box on a form who's selection determines the records shown in a Sub-Form. However if there is more than 1 record in the Sub-Form and I try to scroll or navigate to the nest record I get an error message Saying that my action will create a duplicate record and it will not me allow me to view the next record.



I merely want the Sub-Form to be read only and I have set all the editing functions etc. to No.
Can someone please give me some pointers at to where I am going wrong.
Combo Box is fed from one table and sub form from another. The tables have a one to many relationship.

[rpeare]

Is your combo box unbound or bound? if it's bound that is likely the problem. Your control source for the combo box should be blank, then you'd want to requery your form in the ON CHANGE property (or ON EXIT etc).