I think ive gotten myself a little lost!
I click on a field(PartClick) on a form(frmWOViewer) which open's a form frmBomViewer puts the value from PartClick into SearchBox and then requeries.
I click on a field(PartClick) on a form(frmWOViewer) which open's a form frmBomViewer puts the value from PartClick into SearchBox and then requeries.
Code:
Private Sub PartClick_Click()
DoCmd.OpenForm "frmBomViewer", , , , , , [frmWOViewer].[PartClick] = " & [frmBomViewer].[searchbox]" & Me.Requery
End Sub