Search results

I have Table1 that I want to combine with Table2 to create a query. Table1 has the following column fields: GroupID | MyName| Age | Animal The table has the following fields: AnimalID | Animal | Rating | Mood I have a relationship set up linking `AnimalID`, `Animal`, and `Gender`...

In that case, is there a way to access the state of the report when the fields are linked? Filtering the report leads to the original issue of this thread.

the filtering is done using code in AfterUpdate, linking Master Fields (combo boxes) and Child Fields (column names in report) together.

On a side note, I'm facing another issue that is related to this, so I hope it's ok I just post in here. How can I access the filter criteria of the report based on the LinkMasterFields and LinkChildFields linkage? I tried to do the following, but str returns an empty string: With...

Apologies, I must have missed it. Thanks! And thanks @arnelgp for providing me with the foundation to guide me forward.

I actually figured it out, but I'm not sure if this is the correct approach. Can you confirm? I want to be a better developer, not just write hacky, bypass code. Private Sub comboBox_FilterByRating_AfterUpdate() 'arnelgp If Len(Me.comboBox_FilterByRating & "") <> 0 And...

Please see new attachment. I added in a "Position" column for the report. I was able to get it to filter using "BOTH" filter combo boxes thanks to @theDBguy, but I'm not sure how to do it, if there's just one filter selected?

What syntax did you use?

I'd figured that would have done it, but I got an error: The code looks like this: .LinkMasterFields = "comboBox_FilterByRating; comboBox_FilterByOther" .LinkChildFields = "rating; other" I also attempted: .LinkMasterFields = "[comboBox_FilterByRating]; [comboBox_FilterByOther]"...

Also this code: .LinkMasterFields = "[comboBox_FilterByRating]" .LinkChildFields = "rating" Do you know how if it's possible to link and do a "AND" of multiple fields? What would the syntax look like?

Excellent, I actually just figured it out as well but I think I did it sort of a cheat way since Navigation Forms dont play fair: Private Sub comboBox_FilterByID_AfterUpdate() Dim temp As String temp = Forms(Screen.ActiveForm.name).Controls("NavSubfrm").Controls("comboBox_FilterByID")...

The original design did not call for this functionality. And yes, I was referring to the one adjacent to the navigation buttons. Thanks for the confirmation!

I've temporarily fixed causing the run-time error '2467', but the issue of the current value in the combo box remains. Can someone check the latest demo and open up "Form 1"? Once it's open, select a value in the combo box. The report will filter fine, but the value is not retained in the combo...

Simple question, is there any way to set the width of the search box in a datasheet, either via VBA or its Property Sheet? I'm no expert, but I cant find any way to do that and I believe it's an application defined setting, but wanted to ask experts on this. Thanks

I've created a sample database that produces the same issues as in my real database. Can you please inspect?

I have a Navigation Form with multiple tabs. Each tab contains a subform with a different report, as well as buttons. In one of my tabs, I have a report that I want to filter based on a certain criteria. I created a combo box on top of the report, which filters all items in the report based on a...