I have a list box with 3 columns, 1 bound and 2 displayed. What I want to do is select an item in the list box, then open another form and then have a text box display the 2 displayed fields from the previous form. I have the text box on the new form referring back to the list box, but the value that is showing is the bound value, which doesn't have any meaning. Any suggestions?

Thanks,
-Tim

Hi Tim,

If you open the second form from the first form (say by double-clicking the listbox) you can:

1. base the second form on a query that concatenates the two fields displayed in the listbox, and

2. filter the second form by the bound field from the listbox.

Here's what I mean:

Say your list box lists three fields: CustomerID, CustFirstName, CustLastName. CustomerID is bound. You want the textbox on form two to display the customers full name, i.e., [CustFirstName] & " " & [CustLastName].

First, use the following query as form two's record source:

SELECT
  tblCustomers.CustomerID,
  [CustFirstName] & " " & [CustLastName] AS CustomerFullName
FROM
  tblCustomers;

Bind your textbox on form two to the aliased field in the query (CustomerFullName).

Second, place this code in the listbox's double-click event behind form one:

Private Sub List1_DblClick(Cancel As Integer)

    DoCmd.OpenForm "frmCustomer", , , "CustomerID = " & Me![List1]

End Sub

The where condition synchronizes the two forms, and the concatenated field populates your textbox.

HTH,

Bob

Bob..

Thanks a lot!! That worked very well.

-Tim