Running a button from a buttion in a different form.

[redekopp]

Greetings, im having a bit of issues coding this correctly. I keep getting variable not defined error. The theory is I click on a button and if the (status) field = "NEW", then it opens my search form (frmFileSearch), sets THAT status field (cbostatus) to "NEW" and runs the search button (cmdFilter_Click) to populate the results.

This is the code I got so far.

Private Sub Command2_Click()
If Status = "NEW" Then
DoCmd.OpenForm "frmFileSearch", acNormal
frmFileSearch.cboStatus.Value = "NEW"
frmFileSearch.cmdFilter_Click = True
frmFileSearch.cmdFilter_Click = vbClick
End If
End Sub

im sure im missing something basic! Thank you in advance

[rpeare]

If they are bound forms why not just requery the form after populating the status with 'new'

Is there some other code running with your click event of the secondary form? If so you create a function and call the function from both your click event and when you open the form.

[pbaldy]

The command button would have to be public rather than private, and the code would look like:

Forms!frmFileSearch.cmdFilter_Click

[redekopp]

That worked thank you, does changing it to public affect anything else in the long run or should I be okay?

[pbaldy]

The only affect I can imagine is if you had a button on another form with the same name. An alternative as rpeare suggested is a function you call from both events.