check boxes automatically checked

[thrust]

I have a form with two columns. In the first one I put lab test results (which are numerical values) while in the second one there are corresponding yes/no check boxes indicating the result as normal or abnormal.
I want the corresponding check boxes automatically checked when I insert the lab results.
I welcome your suggestions.

 

[ajetrumpet]

this is basic. review your property sheets for forms and tables. it's called DEFAULT VALUE.

 

[missinglinq]

Adam: What does a Default Value have to do with the conditional ticking of a checkbox depending on the values entered in another control?

thrust: What are the normal values for the lab test, and are you saying you have a single Yes/No checkbox? If a single checkbox, do you want it ticked if the lab value is normal or abnormal?

And where in the world are you? I think the last time I had to manually enter a lab report was about 1980!

 

[dcb]

And where in the world are you? I think the last time I had to manually enter a lab report was about 1980!

Wasn't that just yesterday - when text files were databases and users couldn't click things "just to see what they did" ?

 

[dcb]

Do you just want this to default to "Checked" or do you want it to select the correct option based on the value of the results column? If the latter you would need to give us some more info - ie where would the baseline data be, are the baselines static etc etc etc

 

[missinglinq]

But we clicked them anyway! And, amazingly, we never did any real harm!

 

[thrust]

Adam: What does a Default Value have to do with the conditional ticking of a checkbox depending on the values entered in another control?

thrust: What are the normal values for the lab test, and are you saying you have a single Yes/No checkbox? If a single checkbox, do you want it ticked if the lab value is normal or abnormal?


And where in the world are you? I think the last time I had to manually enter a lab report was about 1980!

For every lab test, for example blood urea, or blood glucoze, or low ensity lipoprotein i have a text box for entering the result which is a number, but i also want to put close to every text box a triple state check box (that will have a control source property a yes/no field in the same table) that i want it automatickly ticked when that number is inside a normal reference range (of course if the corresponding text box is filled with the result).
I mostly want to work with check boxes to save time as a patient brings into my office his biochemical profile.
Coming from Greece.
I'm only interested in ticking as normal or abnormal in my database some of the results a patient brings in a paper and in a few cases fill in the corresponding text box the numerical test result. The problem is that i don't know what it needs for the conditional ticking, an expression, a code or something like that...

 

[dcb]

Hi

After update of Lab result Box:

Dim lngLR, lngNR as long

lngLR = Nz(Me.tbLabResult,0) ''Lab Result trapping for null
lngNR = Nz(Me.tbNormalResult,0) ''Normal Result trapping for null

If lngLR = 0 Then
MsgBox "Your Lab result is impossible" ''Cannot compute
ElseIf lngNR = 0 Then
MsgBox "Please enter Normal Result" ''Cannot Compute
ElseIf lngLR <> lngNR then ''LR is not = to normal
Me.cbNormAb = True ''Set checkbox true
ElseIf lngLR = lngNR Then ''Lab result = Normal
Me.cbNormAB = False ''Set Checkbox false
End If

This should give you a starting point
You most likely need two boxes for the normal results (top and bottom limits) or a better design would be a table to reference as the notmal result is static and therefore there is no need to type it in all the time