Need help with data display

[Buakaw]

I have a form with a text box. The control source of this text box is fkPaymentMethod.

fkPaymentMethod is a number stored in table tblPaymentDetails.

fkPaymentMethod is actually a foreign key from another table called tblPaymentMethod.

Fields of tblPaymentMethod are:

Autonumber Text
----------- -----
PrimaryKey PaymentMethod

It's data contains:
1 Cash
2 Cheque
3 Automated Bank Transfer

I want my text box on my form (with control source as fkPaymentMethod) to display as "Cash", "Cheque" and so on, instead of "1", "2" and so on.

Does anyone know how I can do this? Thanks.

[PrintShopSup]

The control source should be query of tblPaymentDetails. Set the Bound Column of the control source to 2.

Edit.
You would have to change the text box to a list box. Sorry.

[Buakaw]

This text box is for display purposes only. It is to display past transactions, so for that reason I don't want to use a combobox, because it's not supposed to be editable.

Anyone please?

[thhui]

You can set combobox to be locked (not editable).

[PrintShopSup]

I'm wondering what is the control source of the entire form. Perhaps you could create a query "joining" the Payment Method to the foreign key. Then use that as teh control source of the form. This would alow you to set the text box to the Payment Method field from the query.

Make sense?

[thhui]

RecordSource or RowSource is related to Query, SQL, or Table
while
ControlSource is related to fieldName under the RecordSource or RowSource or
control source could be referred to other fieldExpressions.

Form could only have RecordSource Option and no ControlSource Option.

ComboBox could have RowSource Option for setting the SQL Source

[Buakaw]

Thanks everyone. The control source of the form is a query. I'll try out the different options and report back.

[Buakaw]

Yay! It works! I ended up using PrintShopSup's idea. Learned something new, thanks everyone!