DoCmd.OpenForm "FormName", , , "[ID]=" & Nz(Me.ID,0)
Yes. Try it out and let us know what happens.Would I put that in the 'after update event' for the search box,
View attachment 74447
Try it this way:syntax error when i do it like this:
Me.Trackertbl_subform1.Form.Filter = "[ContentNum]='" & Me.Text2* & "'"
Me.Trackertbl_subform1.Form.FilterOn = True
Me.Trackertbl_subform1.Form.Filter = "[ContentNum] Like '" & Me.Text2 & "*'"
"Field1 Like '" & txtSearch & "*' [b]AND[/b] Field2 Like '" & txtSearch & "*'"
Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number.
For example, the number 123.45 has a precision of 5 and a scale of 2.