Relative Content

Tag Archive for vbaformsms-access

How to use MS Access button in Main form to update list box in Subform?

I am building a Microsoft Access database form that has a couple of subforms, each in their own tab in a tab control. I also have a list box inside one of the subforms that displays all records that match the Primary Key of the record open in the main form. Let’s call those primary records A, B, C… and the subform records that match 1,2,3…

Syntax Error when clicking on Button in MS Access form

I am creating a database, and I want to generate a UniqueReference for each entry – the format is YY-0000. In the form, I have put a button with the following code, but it coming up with an syntax error and I can’t work out how to fix it.

Controling data in bound Form

I have a Form bound to a table, but when I save, for which I have a button, I need to do some manual flag setting. The saving works, but I noticed that because it’s bound, it saves anyway. How can I prevent the automatic saving, although its bound? Is there a way of interrupting before_update() or something?