For the past 2 and a half hours I've learned that my form needed to be have Recordset Type = Dynaset (Inconsistent Updates). For a majority of this time I've been searching and puzzling about where I can find this property so that I can change it.
Some links I've tried (not including my google searches):
- http://www.know-access.com/view/7723-use-one-form-for-data-entry-into-multiple-tables.html#expand
- http://www.access-programmers.co.uk/forums/showthread.php?t=180566
- http://office.microsoft.com/en-nz/access-help/edit-data-in-a-query-HA010097876.aspx#BMchange
- http://www.access-programmers.co.uk/forums/showthread.php?t=168744
I've even tried video tutorials, but I didn't have any luck.
No where did they tell me the most simplest thing:
- In the form, go to Design view.
- Right-click, to select Property Sheet.
- The Selection Type should equal Form; this can be chosen in the drop-down menu below the words 'Selection Type'.
- In the Data tab, in the second row, is the form property "Recordset Type". And in the column next to it, I can choose "Dynaset (Inconsistent Updates)".
- Yay!
Yes, I'm a total n00b.
No comments:
Post a Comment