Full Version: Subform Data Not Staying With Record
UtterAccess Forums > Microsoft® Access > Access Forms
I have a subform using a query from a table with my foreign key. On the main form, I have a check box that triggers it to fill in dates on the subform. It's datasource is the main table and has the primary key. Works great until I leave the record and come back. When I come back to the record, the dates are blank but stored in the database. If I check the box again, it populates the dates and creates a second record and again is blank when I leave the record on the form and come back. I have the subform linked by primary and foreign keys.
Any ideas? I want the dates to stay with the record.
I think I figured it out. My foreign key was set to autonumber. I changed it to number after editing the relationship and it seems to be working.
That'll do it.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.