Cant point the form check boxes to the table for update.

[messenger69]

I created check boxes [yes\no] in a form that gets its data from a table with yes\no fields that I want to point it to. Why am I not able to make it point to the fields in the table to update it?

 

[PHV]

Take a look at the ControlSource property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bitmite]

3 things

1. check the query bring in the data if you can not edit in it then the form will not be able to edit the field.
(run the query and try editing a field)

2. Check to make sure the Allow Edits property on the form in set to True

3. make sure the field is not locked.

Brought to you By Nedaineum
|
|
The port to Geektron

 

[messenger69]

I just realized that I want to update the table from the check boxes in the form. I am not sure how to structure this expression in the builder.

I understand the Source Control Properties, but I am unsure of the structure of the exression.

 

[bitmite]

If you place the table name in the Control Source of the form and the place the column name in the control source of the field the updateing will happen automatically everytime you change the value on the form.

Brought to you By Nedaineum
|
|
The port to Geektron