One macro causing another Macro to not finish

[Montez659]

Good morning (afternoon, evening) all!

I will try to explain this best I can, and will try to get a snapshot of what I am talking about here in a few after I figure out how to do it.

I have two forms, one a "list" and the other a details. One is essentially in datasheet view and the other individual records. There is a formula in the list so that if a user clicks on the the word "Open" it will apply a filter to the "details" form so that record will show. Clicking on "open" triggers an On Click event. Halfway through the Macro running as the code is called to open the form, the Macro halts to trigger the On Load event of the "details" form. All works well like this even though as I step through the code it seems like the rest of the "On Click" code doesn't trigger.

When it ceases to work properly is if I try to apply a filter to not show Archived records in the On Load event of the details form. If I do the simple code of ApplyFilter, the only thing that happens when the user clicks on "Open" is that it goes to record 1 instead of the correct record.

I will post the code or screenshots of the code here in a few.

 

[boblarson]

Yes, please post any available code or macro actions/conditions/arguments so we can see what is going on. Do so for all of the applicable events.

 

[Montez659]

Since I can't do much in the way of attaching or downloading any utilities, I copied the screenshots to my dropbox.

http://dl.dropbox.com/u/17000917/ScreenshotClick.jpg

http://dl.dropbox.com/u/17000917/ScreenshotLoad.jpg

By the way, these don't show where I had the ApplyFilter, but it was located after all of the other arguments on the On Load event.

, [Tasks]![archive]<>True,

 

[Montez659]

Hmmm, well, after all that it seems to be working now. I have a love/hate relationship with Access when that happens.

EDIT: I take that back, it is not working. I put the code for the filter in the wrong place.

 

[Norie]

What's the purpose of the ****** event?

It seems like you want change what happens when the form opens?

 

[Montez659]

First off, I have to say that there is a lot to this I don't understand. This (I believe) came from a MS template that the company I work for converted to do what they wanted.

So, if you are talking about the three asteriks (***), then I assumed that was just referring to the same expression as above. However your post had six asteriks, and I wonder if you typed something that the board filtered out.

 

[Norie]

The board filtered out o n l o a d for some reason.

I was just wondering what that macro/code was meant to do.

I think it has something to do with either opening a form to a specific record or for new data entry.

If that was the case I was going to suggest another way to do that, which would hopefully avoid the need to use the load event.

It would probably have needed code rather than a macro though - I'm so used to code that I forget macros even exist sometimes.

 

[Montez659]

I thought something got filtered! When I linked to my dropbox, I had On Load (though no spaces) as the name of my pic and it returned all asteriks!

Anyways, I believe what it is doing is that when someone clicks on the "Open" and triggers the On Click, it is filtering down to a single record (it actually shows 1 of 1 record in the navigation pane on the bottom). This never seemed very plausible to filter down to one record when you should just be able to go to that one record. But I digress.

If you have a better way, then by all means please share. I am a bit partial to VBA myself at times.

And what is it with me and problems with archiving stuff?

 

[Montez659]

Norie, what was your suggestion for this? It would be really nice to get rid of the Macro ****** event!

 

[Norie]

Well, I'm not sure exactly what the macro was meant to do but think it had something to do with opening a form in more than one way.

If that is what it's doing/meant to do then that could be done in code.

Exactly how to do it would be hard to tell without more information, basically what you want the code/macro to do.