<div>
You only need to do this when:<br />
<br />
1) Your query driving the Form's Record Source has more than one table ...<br />
<br />
AND<br />
<br />
2) The query is not 'updatable' with the normal setting of Dynaset.<br />
<br />
Otherwise, there is no reason to do this.<br />
<br />
mx
</div>


You only need to do this when:

1) Your query driving the Form's Record Source has more than one table ...

AND

2) The query is not 'updatable' with the normal setting of Dynaset.

Otherwise, there is no reason to do this.

mx

<div>
<div class="content wysiwyg-content">
I just did the abvoe to all my queries and forms and then realized that some of them may not need this to be done, however, I'm not quite sure which ones...is is OK if all items have this setting?
</div>
</div>


I just did the abvoe to all my queries and forms and then realized that some of them may not need this to be done, however, I'm not quite sure which ones...is is OK if all items have this setting?

Is it ok to set Dynaset Inconsisent to all queries and forms?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.