AlexJimenez
New member
- Local time
- Today, 02:40
- Joined
- Sep 11, 2013
- Messages
- 3
Hello all,
Ok so I am not sure if what I want to accomplish is possible but here it goes.
I have a form "FRM_SearchMulti" which has a list box with 3 columns "PROVIDER_NAME", "TIN", and "NPI". I want to be able to have the user search and double click on the column they want (either "PROVIDER_NAME", "TIN", or "NPI") and once they have double clicked it I want it to open the main form "Contract_Submission" with the entry they searched for. Want I can't figure out is how to make it so that if they double clicked on an "NPI" the main form searches for the "NPI" field or if they double click on a "TIN" the main form searches the "TIN" field. Since it is a list box with 3 columns it highlights the entire row so if they search for example "PROVIDER_NAME" but the entry also has the "TIN" and "NPI" it highlights all 3 available items. Not sure if this is very clear it's pretty hard to even explain. :banghead:. Any help is greatly appreciated.
Ok so I am not sure if what I want to accomplish is possible but here it goes.
I have a form "FRM_SearchMulti" which has a list box with 3 columns "PROVIDER_NAME", "TIN", and "NPI". I want to be able to have the user search and double click on the column they want (either "PROVIDER_NAME", "TIN", or "NPI") and once they have double clicked it I want it to open the main form "Contract_Submission" with the entry they searched for. Want I can't figure out is how to make it so that if they double clicked on an "NPI" the main form searches for the "NPI" field or if they double click on a "TIN" the main form searches the "TIN" field. Since it is a list box with 3 columns it highlights the entire row so if they search for example "PROVIDER_NAME" but the entry also has the "TIN" and "NPI" it highlights all 3 available items. Not sure if this is very clear it's pretty hard to even explain. :banghead:. Any help is greatly appreciated.