Help updating macro code to work in navigation form

[NikoTheBowHunter]

I need some help getting this search macro to work when the form is moved into my navigation form. the form by itself works flawlessly, but I cant seem to get the code to work once moved into the navigation form.



In the "On Click" event for the search button I have an embedded Marco with the following:

ApplyFilter
Filter Name (blank)
Where Condition = [Offender Name] Like "*" & [Forms]![Form: Search]![Text12] & "*" Or [Notes History] Like "*" & [Forms]![Form: Search]![Text12] & "*"
Control Name (blank)

My navigation form is named [Form: Main Menu]
The navigation subform name was not changed so is still [NavigationSubform]

I have tried to update the code to reflect the form being moved into the navigation form but with no luck. Here are some options I tried based on some internet searching, again no luck getting this to work.

[Offender Name] Like "*" & [Forms]![Form: Main Menu]![NavigationSubform]![Form: Search]![Text12] & "*" Or [Notes History] Like "*" & [Forms]![Form: Main Menu]![NavigationSubform]![Form: Search]![Text12] & "*"


[Offender Name] Like "*" & [Forms]![Form: Main Menu]![NavigationSubform].[Form]![Text12] & "*" Or [Notes History] Like "*" & [Forms]![Form: Main Menu]![NavigationSubform].[Form]![Text12] & "*"


Where am I going wrong? Should I not be using a macro within the navigation form? If not could someone provide me with the VBA code I should use? Thanks in advance for any input that is offered. sorry for the noobish question.


Cheers,
Niko

[Bob Fitz]

Try:

[Offender Name] Like "*" & Forms![Form: Main Menu].[NavigationSubform].Form.[Form: Search].[Text12] & "*" Or [Notes History] Like "*" & Forms![Form: Main Menu].[NavigationSubform].Form.[Form: Search].[Text12] & "*"

[NikoTheBowHunter]

I tried the above code and still get the same error message. Maybe the code isn't the issue??? Here is the error message I get when trying to perform the search within the navigation form:



when not opened in the navigation form and using the original macro, have no issues. only when its moved to the navigation form and code is updated to reflect the move I get the above message.

[Bob Fitz]

So is the main form or the sub form bound to a table or a query

[NikoTheBowHunter]

On that I am not 100% sure of. Could you provide some direction on where one would check for this? From what I remember I think I created a blank navigation form and then started putting my other forms into the navigation form from the layout view.

[NikoTheBowHunter]

Not sure if this helps any.

[Bob Fitz]

The form's Record Source property would need to be set to the name of a table or a query and the controls on the form (text boxes etc) would need to have their Control Source property set to a field in the table /query that the form is bound to.

[NikoTheBowHunter]

I apologize but I am a complete noob at this, just a guy who works back in inventory and created a database to track our equipment after watching a couple youtube videos. I am not our IT guy, so again my apologies for the above going right over my head.

The form's Record Source property would need to be set to the name of a table or a query and the controls on the form (text boxes etc) would need to have their Control Source property set to a field in the table /query that the form is bound to.

My forms are as follows:

[Form: Main Menu] (the navigation form) - has no Record Source

[Form: Search] - has a Record Source, its the query I built for the original search form
Within the [Form: Search] header I have an unbound text box [Text12], which has no Control Source and the search button [Command14] with the embedded macro listed above.
Within the [form: Search] Detail section I have 3 fields, all with control sources linked to fields from the query mentioned.

[NikoTheBowHunter]

bumping in hopes someone can help me out

[davegri]

I think the silence here is because no one wants to get into the navigation form tangle, including me. It runs into all sorts of problems such as yours as well as a myriad of others as you try to add functionality to that construction. The frustration is endless.
IMO, you would be much better off in the long run using a main form with the tab control. Each tab would hold one of your subforms. Google "access tab control", then Google "access navigation form". See the difference? Navigation forms are avoided, while tab controls are well supported.

[NikoTheBowHunter]

Thanks for the input. My database will be null and void in 12-16 months so rebuilding it from ground up again for tab control isn't really worth it at this point in time. Though "tab control" looks to be the way to go. I can use the built in "Find" option, does whats needed, not ideal but gets the job done until I toss this DB into the recycle bin. thanks for the input davegri.