Link to home
Start Free TrialLog in
Avatar of James Coats
James CoatsFlag for United States of America

asked on

Custom Tab Issue on Access Form

I had this question after viewing Access Custome Tab for Customer Page.

I have developed a form called "frmCustomers" along with it I created a custom tab. All the links in the tab section "Customer Form Tools" works except for the "Show Lots" link with the filter icon. When you click on this icon it is supposed to take you to the report "rptCustomerLots" to show the lots associated with the selected customer you happen to be on in the form "frmCustomers"

I have been able to figure out how to get the needed forms to work with the other icons but I am having problems with the report "rptCustomerLots".

Any suggestions? ideas?

CustomerDB-2.accdb
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

I don't see any custom tab from your form
Avatar of James Coats

ASKER

Rey,

I think my terminology is wrong. When you open the form customers it's in the "Ribbon" at the top. It has a tab next to the red "FILE" tab that is "Customers".

The icons in that tab all work except for "Show Lots" under the "Filter" icon which is supposed to point to the "rptCustomerLots" report.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Rey,

Everytime I try to download the file it goes to a 404 not found page. Can you repost the link?
Rey,

Thank you I was now able to download the file. Don't know why I was getting the 404 error but it worked now.

So you commeted out the first function ShowLots() and with the second one having the "DoCmd.OpenReport "rptCustomerLots", acViewPreview"
allowed it to work.

And the "USysRibbons" was correctly pointed at the function which fired the "rptCustomerLots"

Is this correct?

Thanks again,

Sam
yes, that is correct