<div>
I found what seems to be an answer:<br />
<br />
We used to first close the Properties windows and then close the Query Generator (the left window), or not closing the Properties windows at all.<br />
When we close the Properties window first before closing the Query Generator (or &quot;Generador de Consultas&quot; in spanish) it works.<br />
<br />
If you can confirm me this, i'd appreciate it :)
</div>


I found what seems to be an answer:

We used to first close the Properties windows and then close the Query Generator (the left window), or not closing the Properties windows at all.
When we close the Properties window first before closing the Query Generator (or "Generador de Consultas" in spanish) it works.

If you can confirm me this, i'd appreciate it :)

<div>
Thank you very much. It seemed to be a bug or badly designed, but it makes sense.
</div>


Thank you very much. It seemed to be a bug or badly designed, but it makes sense.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
We are having an issue with an Access 2007 database, on the design view of a form/subform (see image 1) and then going to Properties on that design view, we go to the &quot;...&quot; icon on the &quot;record origin&quot; or record source (I don't have the english version, see image 2) we go to a panel where we have the table and we choose records to be shown (see image 3).<br />
<br />
We can add records by double clicking on them and we can see in the lower panel the field is added, but when we save, the change is not made. Why can this happen?<br />
<br />
the change can be made via query, but it's not the best way to work and it should work both ways.<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/10_w42/511490/1.jpg" target="_blank" title="design view in form/subform (295 KB)"><img alt="design view in form/subform" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w42/800_511490/1.jpg" /></a> <a href="https://filedb.experts-exchange.com/incoming/2011/10_w42/511491/2.jpg" target="_blank" title="record source or origin (328 KB)"><img alt="record source or origin" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w42/800_511491/2.jpg" /></a> <a href="https://filedb.experts-exchange.com/incoming/2011/10_w42/511492/3.jpg" target="_blank" title="wher the error happens (239 KB)"><img alt="wher the error happens" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w42/800_511492/3.jpg" /></a>
</div>
</div>


1.jpg

3.jpg

2.jpg

Hello,

We are having an issue with an Access 2007 database, on the design view of a form/subform (see image 1) and then going to Properties on that design view, we go to the "..." icon on the "record origin" or record source (I don't have the english version, see image 2) we go to a panel where we have the table and we choose records to be shown (see image 3).

We can add records by double clicking on them and we can see in the lower panel the field is added, but when we save, the change is not made. Why can this happen?

the change can be made via query, but it's not the best way to work and it should work both ways.
   

Access 2007 not saving on form design viewer

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.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.