Text box

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

3 position client ID. Alpha. I only want to lookup records not add or
delete. Once a match is found, I want to display corresponding address, CSZ
on the same form. I'm assuming combo would be best. I cannot get the fields
to change when I select from combo list. I could skip this and use record
selectors at bottom of form(which works) but I really want to use the combo.
I made sample file if explaining would be difficult. (e-mail address removed).
(I posted deeper in a response yesterday.) My deadline is nearing.

I found forms 2000 sample database. Using a subtotal from subform does what
I need. combo the bill to and the bill to's address changes instantly. I
just can't duplicate using forms wizard, making a main / sub report. ???/
Thanks.
 
Here is what worked for me:
I let the combo box look up along with the ID, the other required
information as well. But in the Column Size, I set the others to 0"; so only
the ID will show but the other information is a part of the Combo Box as
well. (Remember to set the Column Count to the number of columns you are
looking up as well).

Then in the Combo.Change()
Save the Combo.Column([column number], Combo.RowSource) to a variable.
Here the column number is the column number of the field you want to appear
on the form for the selected ID. Remember this is zero based, so if your
field is the 3rd column your column number is 2.

(This will select the particular field from the "matrix" represented by the
Column Numbers and the RowSource.)
This saved value can be displayed in a text box on the form by sending focus
to it and then once value is assigned sending focus back to the Combo.

I hope it works for you as well.
Good Luck.
 
Back
Top