displaying data keyed from different field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having troubles displaying data in a form. When the entry is keyed I have a credit card number from a list of numbers each number is attached to a different card, Esso, Shell etc.. underneath the card number I want the card to display. My table of Credit card numbers has the field cardnumber and then supplier. But I am having trouble getting it display the information and then enter them into the table for all information. I get an error message and the supplier goes into the credit card field. Help please
 
Hi Arlene,

Perhaps the simplest way of doing this is to add an extra column to the
listbox or combobox that displays the list of credit card numbers. E.g.
if it's RowSource is now something like

SELECT CardNumber FROM CreditCards WHERE CardUserID = CurrentUserID
change it to
SELECT CardNumber, CardSupplier ...
Hide the column by setting its width to 0.

Then in the AfterUpdate event procedure of the control, put the value in
this column into the textbox where you want to display the supplier.
 
Back
Top