Button Not Working - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Button Not Working

Carlos Espinosa

6 years ago

Hello Richard,
So I have a Transportation DB. In it VendorT has companies that provide the service whith is detailed info, RouteT, routes assigned to each vendor and StopsT which includes all stops within a Route.
Created a VendorF which includes VendorRouteSubF. It has an invisible button that upon clicking on the Route it opens StopsF.
StopsF has a vendor Button which is supposed to get you back to the VendorF. It works as it should for all except one Route. When I click the Vendor Button it takes me to a different vendor.
The querry which its getting the info from has the correct VendorId, and displays the correct vendor.
Any ideas on how to correct this?

	Richard Rost @Reply 6 years ago
Carlos, this is one of those questions that is almost impossible to answer without being able to actually see your database. Can you post the VBA code in the button?

	Carlos Espinosa OP @Reply 6 years ago
The button runs on a macro.

	Richard Rost @Reply 6 years ago
OK. What are the macro steps? Or convert the macro to VB and let's see what it's doing.

Carlos Espinosa OP @Reply

6 years ago

Figured it out.

StopF opens to show the stops in a specific route number. The VendorID on the VendorT was correct but somehow it was changed on the query, StopF was getting its info from. Don't know how that happened.
I thought since the query gets it's info from the Table, the info on the query would be correct.

If by mistake the info on a query is changed, and you catch it while going through the table and fix it there, shouldn't that correct the problem?

	Richard Rost @Reply 6 years ago
Queries don't hold data. They just display what's in the underlying table. Maybe you're missing a REFRESH somewhere? Dirty records? It's really hard to tell because I can't visualize what's going on in your database. It's usually much easier to fix if I have the database in front of me. I'm not familiar with what you've built.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View