i need some help regarding true/false update querys

[adrian1992]

I need a true/false value data type to Only MultiSelect all information in a datasheet that has been filterd in a form
when i create a update query it renders all of the data as a true(tick) value when i only need to tick the filterd information

eg
i have CRM Customers relasionship managment system in place that "filters" inforation by 0.5.4.3.2.1 i need access to select all 5's or 4 or 3 or 2 etc.. to be true(ticked )
HELPPP! PlAse
its my first databse from scratch and its litrely the last thing i need to finish it thanks so much to every one who will help and who has had a look

[NTC]

As I interpret your question (...and maybe not the correct interpretation....): a continuous form cannot have an unbound text box. ...well 'cannot' is not exactly true....but its behavior is not intuitive at first. Think about the continuous form when it is in design view - - it displays a single record's controls. Then think of the continuous form in normal view - - it is displaying many records' controls. So an unbound field (control) is common to every record. Thus any value placed into that unbound text field in the continuous form is having a value placed into all records.

The only solution is to add the true/false field to the table itself. Then put the control on the continuous form - it is bound - and you can place a unique value into a unique record.

[adrian1992]

hey man thanks for replying your amazing created a fried with a ture/fale data type in the main table