Form SubForm Problem

[BartK]

Hi all, I am very new to Subforms, here is what I have:

TblEmployee(main table), TblEquipment and TbleEmployeeEquipment (junction table)

what I would like to do is have my subform be able to store data that I input into it to TblEquipment. Is it the same as a regular form or is there a trick to it. I believe I've got it setup correctly, however it is just reporting back information as if it were a select query. Any help would be appreciated.

 

[MarvinM]

Hi Bart,

If you have it set up correctly, then any new records that you add in the subform should simultaneously be added to the table (Record Source) that is connected to that subform. It's no different from if it were a main form.

Are there any required fields that don't exist on the form? That would prevent a record from being added. Is the issue that the data is not getting saved or that the form is not showing the newly added data?

 

[BartK]

No required fields, like I mentioned before I am VERY new to SubForms. I even used the wizzard and wysiwyg. Thank you