Add records in a query-based datasheet form
Posted on 2006-05-15
In an Access project (Access front-end, SQL Server back-end)...
I have created a datasheet form based on a query that queries two tables.
This datasheet form is then used as a subform on another form.
I have designated one of the two tables as the Unique Table so that users can edit data within the subform.
Is there a way to allow users to also create new Unique Table records via the subform?
The subform's properties are set to allow additions, deletions, and edits, and the subform type is set to Updateable Snapshot. Thought I'd done this before, but just can't duplicate it...