>If I create a combo box, and the possible values that this control lists come from a table, then I set:
>
>combo1.rowsourcetype = 1
>combo1.rowsource = thetable.serialnumber
>
>
>If I want to store the value in another table, then I set:
>
>combo1.controlsource = patient.patsernum
>
>
>If the patient already has a serial number (ie patsernum = 12345), when I load the form, why isn't 12345 displaying in the combobox as the existing value, even if it's one of the possible choices in the dropdown?
>
>CM
You want your rowsourcetype to be 6 - fields, not 1 - value
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.