Prev: checking duplicate values on data entry
Next: A2002 SP3: Exception when using Listview control
From: leahf via AccessMonster.com on 3 Feb 2010 05:02
Thank you very much.

Leah

John W. Vinson wrote:
>>The user should be able to just pick the social security number from a combo
>>box which will then fill in the name of the student, and then the user just
>>adds the class (from a list of classes) and puts in the start date.
>
>In that case, you can just use a Combo Box storing the StudentID and
>displaying the SSN. You can include the student's name in the combo's
>RowSource - set the width of that field to 0 in the combo's ColumnWidths
>property. Put another textbox on the form with a control source
>
>=comboboxname.Column(n)
>
>using the name of the combo box, where n is the *zero based* index of the
>field you want to display - e.g. if the name is in the fourth column use (3).

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1

First  |  Prev  | 
Pages: 1 2
Prev: checking duplicate values on data entry
Next: A2002 SP3: Exception when using Listview control