Cash Receipt form

[Newby]

I have a form with 2 combo boxes. The first box specifics whether the renter is active or non-active. The 2nd combo box list rentersID, renterName, and apartment # filtered by the active selection. When I select the Renter, only the renter's ID field show in the box. I can see all three field when I am selecting, but after I select I see only the renter ID. How can I did the renter name and apartment # to display as well? The form is unbound.

[rpeare]

put two unbound fields on your form
name them 'tentantname' and 'apartmentnumber'

in the ON CHANGE or ON EXIT property of your combo box

assuming your tenant name is the second column of your combo box and the apartment number is the third column use this:

tenantname = [comboboxname].column(1)
apartmentnumber = [comboboxname].column(2)

I would also set the enabled property of the two fields to FALSE and the locked property to TRUE