I have a form that contains a subform. The subform contains a list of items (test types) that are pulled dynamically from one of my tables (TestType).
The idea is that the user can go through the list and check off as many test types as he/she wants. These values are then stored in a different table (Job_TestTypes) which tells which test types are associated with a particular job.
I didn't create the subform, but I want to make a change to it. Currently it lists all the items and a checkbox beside them, however at the bottom of the subform, after the last valid entry, is a line where the user can apparently enter a brand new entry to this table.
This is something that I don't want the user to be able to. Is there any way I can set up the subform to only display current data in the table and not allow the user to add a new entry to the table?
Does this make sense at all? Can somebody please help me?
The idea is that the user can go through the list and check off as many test types as he/she wants. These values are then stored in a different table (Job_TestTypes) which tells which test types are associated with a particular job.
I didn't create the subform, but I want to make a change to it. Currently it lists all the items and a checkbox beside them, however at the bottom of the subform, after the last valid entry, is a line where the user can apparently enter a brand new entry to this table.
This is something that I don't want the user to be able to. Is there any way I can set up the subform to only display current data in the table and not allow the user to add a new entry to the table?
Does this make sense at all? Can somebody please help me?