Find by Name, Link by ID

  • Thread starter Thread starter Bonnie
  • Start date Start date
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!!!
 
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
 
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!!!
.
 
Back
Top