Data entry into MS Access subform
Posted on 2007-07-31
Redoing a frontend/backend MS Access mdb setup with about 5 users. I know there is a simple answer to this but it has eluded me for the past 5 hours.
I have a form, call it frmMaster, with a subform, call it frmSubform (easy enought right?) The field SubformID forms a one-to-many relationship with the SubformID field in frmMaster. Now this works great when i'm scrolling through the records, la la la, but everything bursts into flaming debris if i try to add a new record to frmSubform. I get an 'Invalid use of Null' error message and the autonumber value that is entered into SubformID does not cascade into the recordset underlying frmMaster, even after refreshing.
Any thoughts on how to get around this? I suppose I could open another form and use it for data entry but this is an app i'm developing for a call center so the less forms that a user has to open, the better. I really just need to find some way around the inability to enter data into a subform.
Thanks in advance.