check boxes (1 Viewer)

[Dannyc989]

Hey Folks,

I have a form with a sub form... I want to know if the following is possible...

If I have a check box on Master Form and make it there is a tick in it, can I make a check box on the sub form do the same i.e.

Master form ticked = sub form record ticked and visa versa

Many Thanks

 

[Galaxiom]

Yes but that requirement sounds like a design normalization error.

 

[Dannyc989]

ok so how would you do such a thing and avoid the error

 

[Galaxiom]

ok so how would you do such a thing and avoid the error

Your original post did not mention an error.

I would need to know about the meaning of the checkboxes to offer any advice.

The bottom line is that storing the same information in two places in a database is almost invariably wrong.

 

[Dannyc989]

There is reason for my madness...

I have a table called quotes which creates an automated quote ref...

When the client orders said quote it then appends certain information to a different table called projects which creates a different automated number as a project ref...

However if the project is cancelled I have a checkbox to show this in the projects table...

The reason I want it to do the same thing in quotes table is because the quotes table is linked to a live form showing sales for the year which requerys every 30 seconds and as not all sales are projects, when the project is cancelled it needs to show in the quotes table and it will therefore be deducted from the live sales form..

I hope that make sense...

 

[Galaxiom]

The RecordSource query of the Live Sales form should suppress the cancelled projects using the checkbox in the other table.