Form

[advpay]

Hi,

table is

Salutations
SalutID is autonumber
Salutation description ex. MR=1 MRS=2 from SalutID

I store the 1 in the customer table for MR,
In my form how do get the MR to show up instead of the 1? I just keep getting the 1 for the value.

Thanks

 

[desiboy]

I assume your form's recordsource is a query. If not, you have to create a query with two tables: customers, salutations. One of the columns of the query should be Salutations.description instead of the column from customer table that stores the SalutID.

 

[THoey]

A couple of steps:

1. Create the list box to display both fields, SalutID and Salutation.

2. Use a query to populate the listbox by setting the RowSourceProperty.

3. Set the column width for the SalutID portion to 0, making that data invisible.

4. Set the BoundColumn to the column that contains the SalutID.

5. Set the Control Source to the Field in the table.

I think this should do it...

 

[advpay]

Thanks, now my table lookup box for that field is MR and the field is still stored in the Customer table as 1; thats great...but on the form I am still getting the 1? I set the control source on the form to the Salutation from the Customer table?