Search Button in a Form not Working

[June7]

No. Subform/subreport container control is component on a form or report. Like a textbox or combobox you create one by selecting the tool from the ribbon Design tab and click on form to create control. Select the subform/subreport tool and click/drag to create a box on the main form. This creates the container. Now set the ObjectSource property of the container to the object you want it to hold (table, query, form, report). Just as demonstrated in the video. You must understand that a subform is constructed with a container control that holds an object. I have already described and the video demonstrates how to select a container control already on a form. I suggest you review the video again and other tutorials if needed and reread earlier posts. I cannot help you any further until you understand how a subform is built.

The code you show in first post is setting form recordsource to display records that meet filter criteria. If only one record meets the criteria then that is all that will show on the form.

[spideynok]

Hi June7. Sorry for my stupidity. Hmm. BTW. I already change the Subform Container Name as you said on post #8 and I also did the code that you putted on it. But still it shows me the same result?

[spideynok]

Let me show you sir.

• Here's the code.

Figure 1


• In access which I think I rename the container name.
Figure 2


• When I click Form View. All records will appear which is Okay.
Figure 3


• When I search without inputting a value. This is what happen which is wrong because in my first project with the same use/function like this. It will show me all the records when I don't put any value in the textbox. (FIGURE 3)
Figure 4


• When I put a value on the textbox this is what happen which is also wrong. I input a Card Number which is not a Card Number of Jingu Anita(who's always appearing when I search NULL value) and this is the result.



what I think on what's happening is that Jingu Anita is the only one that my system can identify. hmm can I ask again what's wrong? Sorry for being a noob sir. Please be more patient. Thanks

[June7]

Okay, looks like you got all the edits I described. Something must be happening in the BuildFilter function. Step debug, follow the code as it executes one line at a time. Check the value of variables, like the reference to Text16. Find where behavior deviates from expectations, fix, run, debug, repeat.

[spideynok]

Okay sir. I'll do what you said. But I would like to ask some question. On the database that you edited, does it RUN like that? or different? Thanks!

[June7]

The edits I suggested work fine for me. Here is the file. See if you can figure out why yours is working wrong.

EDIT: Purpose served, file removed.

[spideynok]

Thank you. Still figuring out, but I can't see what's wrong. Line by line I've checked it.

[June7]

You could now send me yours and I will try to find the difference. The one I sent is working for you?

[spideynok]

Yes, the one that you send to me is working and great!
https://www.cx.com/mycx/files/my-files/InstantCard2.zip

here's the link bro.

[spideynok]

If not work. This https://www.cx.com/mycx/share/CiEG6H...stantCard2.zip

[June7]

Neither of those links will work for me. Box.com has never given me any problems.

[spideynok]

oh I see. I'll get back into this sir June when I got home.

[spideynok]

Hi June7 I just noticed this query table on the navigation pane on the one you've worked. Please see and I would like to ask if what is the use of this query? Thanks!

[spideynok]

BTW I'll provide the database as soon as I got home and uploaded it to box.com.

[June7]

I don't know why it's there. Don't remember creating it. I opened it and there are no tables/queries in the SQL. Don't know how could have been saved. Searched VBA and no reference to it.