Yes or No Checkbox Help

[bronson_mech]

Hello frndz,



I need a help, I have created two separate form & Table for Issued material & Return Materials, I have created a yes/no checkbox for each line item in Issued Material… if that line item is a returnable tool then I’ll check that yes or no box, so if the box is checked then it is returnable tools. Ok now come to return material form…. If I enter the issue slip No (autonumber created in Issue Form) it should only the returnable tools which I Checked in issue form…. I can’t able to figure it out.. can anyone help me in this pls………

[NTC]

The Return Material Form should have a combobox in the header set to look up a record in the table (this is an option to choose with the wizard when putting the combobox into the form).

First check that this works - i.e. select a slip number and the data in the form changes to it.....

Once that works then you need to modify the query that drives the combobox so it only displays Yes checks - - to do that you have to go to the Properties of the combobox and modify it's record source query - - add the Yes/No field and criteria that it must be -1.

[bronson_mech]

Thanks a lot NTC for your suggestion,

the thing i want is i have a form with subform, in the main for i have a yes/no checkbox named as return, if i click this yes/no box all yes/no box should be checked in subform.... Like Select All Option.....

[NTC]

You require an UpdateQuery applied to the subform's table's field. You then need to fire that UpdateQuery based upon the check of the field in the mainform. You actually need 2 ; one for checked and one for unchecked with logic as to which is to fire....

just fyi.....This is not normalized structure and you shouldn't have to do this - with the main form's check as the parent field - - one can always join to it to know the status of a child record and thus do not need the check field in the child table.

[orange]

Can you show us a jpg of your tables and relationships? As NTC said you do not have a normalized structure, and that may be causing you more grief than you know.
Proper table structure to support your requirements is critical.
You may wish to research Normalization.

Good luck with your project.