I've got a form that will only let me view/edit the first record in the table. My other forms, which are subforms within the problematic form, are set up the exact same way and functioning properly (I can view/edit any record from the tables they use as a record source). I've tried making another form based on the same table as the form thats giving me issues, and the same problem occurs, however there is no difference between that table and the other tables.

If I change the data entry property from "no" to "yes", I am able to enter new records just fine. I've messed around with the properties numerous times in case I've missed something, but that doesn't seem to be the case.

I've searched around and posted on a few other forums with no luck. I'd like to reiterate that this form is set up the exact same way that the other, properly functioning forms, which is why I don't understand why it wouldn't be behaving the same.

Any help is appreciated.