Subform can't apply the filter

[ctathrh]

Hi,



I create a sub form with a search function, but as I wanted to search the defect the form can't apply the filter. How to I fix the problem according to the error occur?

In my unbound form platform I also put another sub form but they all functioning well according to the sub form but not the sub form with the search function.

[Gicu]

Without seeing your filtering code it is hard to give you a solution; seems like you do not reference the subform properly in your filtering; when embedded into a main form you need to fully reference it or have code in its own module and use Me.Filter.

Cheers,

[ctathrh]

Without seeing your filtering code it is hard to give you a solution; seems like you do not reference the subform properly in your filtering; when embedded into a main form you need to fully reference it or have code in its own module and use Me.Filter.

Cheers,

Hi,

I can search things that I want to search on my sub form, but when I want to search on my main form the error occur.



This is my apply filter macro on my sub from on my search button



This is my code for the open form in my sub form



Is there any mistake in my code that make my form cannot use the search function?

[Welshgasman]

You have to start with the mainform?
Forms!MainForm!SubformControl!Form.Control

[Gicu]

Here is some more info on how to reference subforms:

http://access.mvps.org/access/forms/frm0031.htm

http://www.fmsinc.com/tpapers/primer...%20a%20control.

[ctathrh]

You have to start with the mainform?
Forms!MainForm!SubformControl!Form.Control

Hi, may I know where do I put this command in my property sheet in my main form?

[Gicu]

You modify the existing macro to include the main form name between [Forms] and [sbfr_GIGsearchlog] in both places.

[ctathrh]

You modify the existing macro to include the main form name between [Forms] and [sbfr_GIGsearchlog] in both places.

I already modify the macro as u suggested but the same error still occur

[Gicu]

Care to share how the modified macro looks like? We can't help you if we don't see what you have. A form's filtering or searching functionality will most likely be lost when the form is embedded within another, as Access will no longer recognize the form itself as being loaded. Have you had a chance to review the two links I've posted in post #5?

Cheers,

[ctathrh]

Care to share how the modified macro looks like? We can't help you if we don't see what you have. A form's filtering or searching functionality will most likely be lost when the form is embedded within another, as Access will no longer recognize the form itself as being loaded. Have you had a chance to review the two links I've posted in post #5?

Cheers,

Hi,

Below is the modify macro, I added my form name [frm_HPCV25] in between [Form] and [sbfrm_GIGsearchlog], but the error still occur.

[Defect] Like "*" & [Forms]![frm_HPCV25]![sbfrm_GIGsearchlog]![Text39] & "*" Or [Defect_Description] Like "*" & [Forms]![frm_HPCV25]![sbfrm_GIGsearchlog]![Text39] & "*"

Other that the macro and all the information I give above, I did not have any code or macro related to this problem to show.

I already review two links you have posted and highlighted, but as I really new to access I did not know where and how I can apply the information given in the links. If you have time some guidance from you will be much appreciated.

[Welshgasman]

That is because you have not addressed the form within the subform control.
Look at the syntax that Vlad linked to and also my comment on the syntax more carefully.