Hello,
I’m having some problems with the implementation of my subfrom grid. I’ve included an image for reference, but the delete option on the navigation bar is greyed out. I am not sure how to get to a point where I can delete rows from the subform. Any assistance will be greatly appreciated.
Hi,
check the subforms properties, datatab if delete is set to Yes
“Allow deletions” is already set to yes
Is the datasource a query having multiple tables ? If so the query needs inclusion of all primary keys to be editable.
I added an image of the data source SQL command. It is pulling from two tables. Not positive what adjustments I need to make though.
add the id and item_id primary keys to the query and the subform grid (can hide)