Storing birth weights

[Dairy Farmer]

John Big Booty's solution works well.

Suggestions:
Have Kg's and g's not just g's, but still store as g's.
Have unbound text boxes that show the conversion dynamically. i.e if you have selected metric show the imperial conversion too and visa vesa.

 

[John Big Booty]

John Big Booty's solution works well.

Suggestions:
Have Kg's and g's not just g's, but still store as g's.
Have unbound text boxes that show the conversion dynamically. i.e if you have selected metric show the imperial conversion too and visa vesa.

These are all relatively straight forward additions to the DB that the OP can consider if he so chooses, it would just be a matter of adding the text boxes and adjusting the code accordingly. The foundations are all there it's just a matter of expanding on what I've already done.

 

[YNWA]

Thanks for your ideas, that db looks good.

I sort of get the concept and can adjust for my needs. Will give it a go and see how I get on.

Cheers everyone.

 

[YNWA]

That solution works a treat, however if I click to next record, the measurements do not clear for new ones on the next record.

They only clear if I then click on a measurement type.

Would a requery or anything sort this?

 

[DCrake]

Use the forms OnCurrent event to clear/reset the controls

 

[YNWA]

Like this...

Dim ctl As Control
For Each ctl In Me.Controls
If (ctl.ControlType = acTextBox) Then
ctl.Value = Null
End If
Next ctl

Edit....

This doesn't work, error on the 4th line, not sure why.

How do I reset/clear OnCurrent()?