IDNumber needs to autoshow when name typed into form

[bebo2]

I am setting up a form to enter contribution data. The users don't want the personal data to be on the same form as the contribution data. But I want the capability of typing in the name (frmContributions) and the associating NameID to pop up. I have a query using tblAddress with tblContributions to associate the two but when I base frmContributions on that query and type in a new contribution by name--the NameID# doesn't show automatically. Is there a way to make that happen??

Thanks for your time!

 

[jimbrooking]

Let's say you have a query called qryNames that has (at least) two fields in it:

NameID - the index to the contributor's personal info. record, and
Name - the name of the contributor

Then you could use the following as the RowSource for the contributor ID combo box:

Select NameID, Name from qrynames Order By Name;

Other settings in the combo box's properties:

Number of columns: 2
Bound Column: 1
Column Widths: Put in something like 0.25" for the width of the NameID field. Default the Name width by not specifying it.

The pulldown for the combo box will show both the ID and the name, but after a name is selected the box will show only the NameID (which will also be the value of the combo box).


Jim