OK, I'm having a lot of trouble with this today. Hopefully this is a simple fix.
I have a form (SPC_Data_Entry_Display_Form) based on a table (Data_Storage_Tbl). Each of these records has info about when and where a measurement was taken. I want to record the measurements in a separate table (Measurement_Storage_Tbl) with a key to link back to the Data_Storage_Tbl entry that these are tied to. All tables are physically in another DB but are linked from this one.
To do this, I created a subform on the SPC_Data_Entry_Display_Form, but somehow the subform is not updateable - if there are no records to display it is completely blank. If there are records, it shows them but does not allow new entries and the old entries cannot be edited. I tried recreating the subform from scratch, but no luck. I'm sure this is something dumb, but please help! Here are the steps I'm taking:
1) I insert a new subform/subreport from the design menu.
2) I select "Use Existing Tables/Queries"
3) I select Measurment_Storage_Tbl and include the fields "Measurement_Value" and "Parent_ID". There is another auto-numbered field that is in the table ("Auto_ID"), but I usually don't bring it in (I've tried and it doesn't seem to make any difference).
4) In the next dialog box, I select the Form field as "ID" and the subform field as "Parent_ID".
5) I name the subform.
That's about it. I've read up on non-updatable tables and it always seems like they are talking about joins and other factors that have nothing to do with my super-simple record set.
So, I hope this is something really dumb, but what am I missing? Thanks in advance for the help.
I have a form (SPC_Data_Entry_Display_Form) based on a table (Data_Storage_Tbl). Each of these records has info about when and where a measurement was taken. I want to record the measurements in a separate table (Measurement_Storage_Tbl) with a key to link back to the Data_Storage_Tbl entry that these are tied to. All tables are physically in another DB but are linked from this one.
To do this, I created a subform on the SPC_Data_Entry_Display_Form, but somehow the subform is not updateable - if there are no records to display it is completely blank. If there are records, it shows them but does not allow new entries and the old entries cannot be edited. I tried recreating the subform from scratch, but no luck. I'm sure this is something dumb, but please help! Here are the steps I'm taking:
1) I insert a new subform/subreport from the design menu.
2) I select "Use Existing Tables/Queries"
3) I select Measurment_Storage_Tbl and include the fields "Measurement_Value" and "Parent_ID". There is another auto-numbered field that is in the table ("Auto_ID"), but I usually don't bring it in (I've tried and it doesn't seem to make any difference).
4) In the next dialog box, I select the Form field as "ID" and the subform field as "Parent_ID".
5) I name the subform.
That's about it. I've read up on non-updatable tables and it always seems like they are talking about joins and other factors that have nothing to do with my super-simple record set.
So, I hope this is something really dumb, but what am I missing? Thanks in advance for the help.