Search Fields

[breadbox]

I want to be able to type in a part number and date range and do a search. How can I create this?

Any help would be great.

 

[breadbox]

Also, I have a text box that has =[DryWeight]/[DeltaWeight]in the control source of Density and if the answer doesn't come back between2.45-249 I need the error to appear, but this code is not working.

HELP


Private Sub Density_BeforeUpdate(Cancel As Integer)
If ((Me.Density < 2.45) Or (Me.Density > 2.49)) Then MsgBox "error check your weights"
Cancel = True
End If
End Sub

 

[PHV]

If Me!Density < 2.45 Or Me!Density > 2.49 Then
MsgBox "error check your weights"
Cancel = True
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[breadbox]

Thanks, for the answer to the second question, it works.

I want to be able to type in a part number and date range and do a search. How can I create this?

Any help would be great.