Find by Name, Link by ID

B

Bonnie

Hello everyone! Using A02 on XP. Have a form bound to a
query with our contract records. Have a listbox linked to
a query of TPAs. Each contract needs a
(T)hird (P)arty (A)dministrator (TPA). Select a TPA in
listbox and the TPA_ID appears in field [TPA] on form.
Contract now has a TPA assigned.

Problem is this: tech wants to be able to navigate the
listbox by TPA_Company_Name (press D,D,D,D to find Dirkson
TPA, Inc.) but I still need to put the TPA_ID number in
field [TPA] on form. Right now, the bound field is TPA_ID
and you can press numbers to navigate. But if I change the
bound field, that field tries to populate my field [TPA]
on my form and, of course, doesn't work.

Is there a way to accomplish this? I'd appreciate any
advice on this. Thanks in advance!!!
 
G

Gerald Stanley

Firstly, change the RowSource SQL to select both the name and Id columns
(name first then id). Then change the ColumnCount to 2 and set the
BoundColumn to 2. If you do not wish the ids to be seen in the dropdown
list, then set the column widths to n;0 where n is a suitable width for
viewing the names.

Hope This Helps
Gerald Stanley MCSD
 
B

Bonnie

Mr. Stanley, you were right where I needed you today!
Thank you VERY much for the info. EXACTLY what I was
looking for and explained so I understood it. I switched
my first and second columns and bound col 2. Works great!
Thanks again for taking the time to help.
-----Original Message-----
Firstly, change the RowSource SQL to select both the name and Id columns
(name first then id). Then change the ColumnCount to 2 and set the
BoundColumn to 2. If you do not wish the ids to be seen in the dropdown
list, then set the column widths to n;0 where n is a suitable width for
viewing the names.

Hope This Helps
Gerald Stanley MCSD

Bonnie said:
Hello everyone! Using A02 on XP. Have a form bound to a
query with our contract records. Have a listbox linked to
a query of TPAs. Each contract needs a
(T)hird (P)arty (A)dministrator (TPA). Select a TPA in
listbox and the TPA_ID appears in field [TPA] on form.
Contract now has a TPA assigned.

Problem is this: tech wants to be able to navigate the
listbox by TPA_Company_Name (press D,D,D,D to find Dirkson
TPA, Inc.) but I still need to put the TPA_ID number in
field [TPA] on form. Right now, the bound field is TPA_ID
and you can press numbers to navigate. But if I change the
bound field, that field tries to populate my field [TPA]
on my form and, of course, doesn't work.

Is there a way to accomplish this? I'd appreciate any
advice on this. Thanks in advance!!!
Click to expand...
.
Click to expand...
 
Top