Thick Box + Sql insert

[krzysiekk]

Hi

I got form with calculated fields next step I created button which will be posted into table data from 6 fields

What I want to do is create thick box and if thick box is not selected for one field and selected for 5 other fields after pressed button script will be posted just 5 fields

I using standard sql insert procedure

Please advice

 

[Galaxiom]

Sounds like you are storing the results from the calculations. This is not normally done. Instead a query is used to calculate the results as required.

How does the user decide which boxes to tick? If this can be expressed as a formula then the whole job can be automatic.

To store the values using SQL, the query is created dynamically in VBA. The code loops through the check boxes and adds the values to the query according to the ticks.