help - Forms SEARCH box

[Sheba]

Hi, my VB skills are at beginner level and I need assistance with this code please. It is code for a SEARCH box on my form. This textbox uses a subform to filter based on the user's input.



I have this code below but I am getting Error 424 "object required" - the 6th line of code is highlighted in yellow. I really appreciate any assistance with this.

Private Sub cmdSRCHBOX_Change()
If Len(cmdSRCHBOX.Text & vbNullString) = 0 Then
SearchForm.Form.Filter = vbNullString
SearchForm.Form.FilterOn = False
Else
SearchForm.Form.Filter = "[TripID] Like '*" & cmdSRCHBOX.Text & "*' OR [PatientID] Like '*" & cmdSRCHBOX.Text & "*'"
SearchForm.Form.FilterOn = True
End If
End Sub

[ItsMe]

The error is because it is looking for a subform container named, "SearchForm".

If you type Me and then dot (.), does SearchForm appear?

[Sheba]

Hi, thanks for your response. apologies, I didn't provide all the details. My main form is PaediatricForm and my subform is called Searchform. Are you saying that in the code, I should replace ALL the Searchform with "Me."?

I tried this anyway and it is still giving error 424

[ItsMe]

As a test, if you type (somewhere in your form's module) Me and then dot (.), does SearchForm appear? This may help you to determine why the error is occurring. Use intellisense.

[Sheba]

If I type "Me."on a blank line, yes intellisense comes up but it has a list of suggestions listed in alphabetical order beginning with ActiveObject which I don't think I need...

[Sheba]

sorry Searchform does not come up

[ItsMe]

That is why you are getting the error.

SearchForm.Form.Filter indicates that you have a subform control named SearchForm. The .Form after the name is looking to the child object which is a form. The .Filter is a property of this form object. You need to make sure all of these are available. Start by getting the name of your subform control/container. While in design view of your form, highlight the subform control and look at the property sheet. Click the Other tab and see what the name is.

Once you know the name, you can use intellisence by typing Me dot and the name then dot...

[Sheba]

thank you!!! the error WAS the form name. don't mind me but I LOVE you right now!