Macro not working in Navigation Form

tcrank472

New Member
Joined
Feb 19, 2008
Messages
12
Access ver 2010
In a Form I have a Command Button that invokes a Macro that looks in a Text Box then performs a record search based on the value of the Text Box. The Macro runs fine when the Form is opened in its own window.

However when the same Form is assigned under a Tab in a Navigation Form the Macro returns an error message. "...cannot find the referenced form..."

Any thoughts on this?

PS: I am not a programmer, I copied the Macro from the sample Contacts db provided by MS Access to my database.
Thanks!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
The form then becomes an object within the tab form so you have to reference that first. So it will look like searching inside a subform.
 
Upvote 0

Forum statistics

Threads
1,224,618
Messages
6,179,917
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top