issues editing records in form

[tcarter963]

I have a form with a subform. In the form I hid a text box for ID, which is an autonumber primary key. The subform has a box for ID, which the default value is the ID from the main form. This is a one to many relationship with the main form being the one and subform the many.

My form also has a date field. I would like to be able to pull up records based on the date and be able to edit/see those records. I can't even go through the records using the navigation buttons at the bottom of the form. When I put a date in that has previous record information in it, I get a referential integrity type error. What am I doing wrong here?

 

[boblarson]

Make sure that the parent form does not have the table that the subform uses for its record source in it and the subform doesn't have in its record source the table that the main form uses for its record source.

 

[tcarter963]

Thanks Bob,

I checked it and the record source is different for the parent form and for the subform.

 

[boblarson]

One more thing to check is that you haven't checked the Enable Referential Integrity between a table in your form or subform and just a lookup table.

 

[tcarter963]

I checked under "Edit Relationships" and Enforce Referential Integrity was not checked....

I was just screwing around and right clicked on the form in Form View and clicked on Filter by Form, now I can click through records and change entries without any issue. I don't quite understand why or how clicking on filter fixed the problem, but I am new to this. Everything seems to be fine now. I closed the form and reopened it and the first time it reopened I had to click on filter again, the next time I opened the form, it opened the way that I wanted to, with the ability to scroll through and edit records. Was this just a bug in MS access?

Bob, thanks for your help. Do you have any good references for explaining what I did to fix this, if any?