On Apr 7, 11:03 pm, "brino" <bdsolutions2...@yahoo.com.auwrote:
hi all !
i have a form where users select a persons name from a drop down
list.
when selected the persons name goes into a field in a table.
this list of names comes from another data base that i've connected
to.
when the user selects a name i want the persons ID number to go into
an ID field as well as there name going into a name field.
how can i do this ???
any help would be great !!
thanks
brino
Scott is right - you should not really have to do this - usually that
is. But since the person's name comes from another database, maybe
you have sufficient reason. Just give it some thought before you
store both tho.
If you want to do it, in the combo box query have both fields even tho
you show only the person's name. In the after update event, write
code to pick from the combo box using me.cboName.column(2) for example
to get the ID. Then store it where you want. The first column in the
combo box row source is 0 if I recall correctly.
-- Larry Engles