Search Button Macro give incorrect field

[jedder18]

I've attached screen shots of the search macro and forms in use.
I am not certain how the macro is working.
It is supposed to be searching for the Episode ID and when selected should open the info for who it belongs to.
However, it is putting that id into the participant name and bringing over the data that matches that.
Not sure when, or how it ever got changed.
The background of the form it ends up presenting the info on is run off a query with the Client ad Episode tables, linked by ClientID

I'm trying to find out how to get it back to searching for the episode and placing the correct info into form that matches the client to that episode.

 

[theDBguy]

Hi. How exactly is the macro executed/initiated?

 

[arnelgp]

edit the macro.
change the GotoControl->ControlName=[Episode ID]

 

[jedder18]

The macro is initiated when you press the search button

 

[theDBguy]

The macro is initiated when you press the search button

Okay, my guess is when you press the button, you didn't have the focus on the right field prior to clicking it. If so, then you should try Arnel's suggestion and simply specify which field to search.

 

[jedder18]

I fixed it.
Had to change the tab order.
the field needed(Episode#) was 2nd in order, the 1 that would populate was 1st.

 

[theDBguy]

I fixed it.
Had to change the tab order.
the field needed(Episode#) was 2nd in order, the 1 that would populate was 1st.

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[jedder18]

so the tab order only worked on the 1st instance of finding the next episode
after that, it keeps putting the episode ID into the Participant ID field even tho I speficied the control name of EPID
Any thoughts? I've tried closing the form in the macro when it opens the next form, but, when going back to 1st form, same thing happens, the ep ID that is being asked for ends up in the participant field and therefore the remaining buttons on the form calling for the episode do not give correct info.

 

[theDBguy]

Are you able to post a demo version of your db for review?

 

[jedder18]

sadly can not post demo version.
It's a huge db, and hipaa rules exist.

anyhow, 1 of the things I did which seem to be working..

The form is started off with a search button to find an ID.
when ID found, there are multiple buttons underneath for multiple forms/reports etc all tied to found ID.

Each of the buttons is a macro, which I added the command close window of the main form that was searching for ID.
IT seems to be working now and gets the focus back to the search ID button when form is reopened.
Seems like alot of hassle, but, it's working and I'm going with it.
It just would not work if I left that form open. Would never get focus back to the correct field.

I will keep you all posted.
Thanks for all the help.

 

[theDBguy]

Hi. Glad to hear you found a solution. Good luck with your project.