Simple piece of code

[Dannyc989]

Folks,

I'm looking for a simple piece of code that does the following...

If the checkbox on the master form is true then on a subform a checkbox is also true, and the same if it's false... Any ideas

 

[Galaxiom]

Since you are apparently not interested in proper database concepts:

Use the Update event of the checkbox to set the other checkbox.

On the main form:

Me.subformcontrolname.Form.checkboxname = Me.checkboxname

On the subform

Me.Parent.checkboxname = Me.checkboxname

I suggest you research the concept of normalization.

 

[Dannyc989]

I can appreciate database normalisation is a good way to work when building a database, however this is a database that was already built, and currently live and working doing other things not just sales, and this is a modification to that, in the short term that is needed quickly, once I get the chance to sit down and pull the database to bare bones and start again with it I will do, unfortunately this isn't my normal work task and I have this on top of that. Many thanks for your help

 

[Galaxiom]

You could have said that in the other thread and I would have obliged.

Starting another thread appears somewhat dismissive.