List Box Data Not Completing Field

[Guest]

I have a list box based on a query combining "FirstName" and "Surname" field
bypression within the query - this works when the query is run. (eg Expr1:
Membership.FirstName & " " & [Surname])

It also works on the sub form where the list box resides in so far as when I
click on the drop down the full list of names are shown as combined, however,
when I select a name, the data doesn't fill in the box - just disappears.

Any suggestions would be helpful.

Regards

Juparo

 

[Rick Brandt]

I have a list box based on a query combining "FirstName" and
"Surname" field bypression within the query - this works when the
query is run. (eg Expr1: Membership.FirstName & " " & [Surname])

It also works on the sub form where the list box resides in so far as
when I click on the drop down the full list of names are shown as
combined, however, when I select a name, the data doesn't fill in
the box - just disappears.

Any suggestions would be helpful.

Regards

Juparo

A ListBox doesn't have a "drop down" so I assume you are actually talking
about a ComboBox. Does the ComboBox have more than one column? If so what
are the width settings of the columns?

 

[Guest]

Do you mean combo box and not a list box?

Check the first column selected in the combo, t can be a field that doesn't
have a value in it (Check the Row source of the combo).

Or, check to which filed the combo is bounded to, also this column might be
blank and this is why no value is shown.

 

[Guest]

Thank you for your replies. I am no expert but the Top Left Hand Corner of
the properties window tell me its a List Box called "Exp1". When I click in
the field a drop down list of members is shown. The names shown are a
combination of two fields from a table "Members" and a joint field created in
a query.

The actual list box is on a sub form with the master/child fields relating
to the joint name.
The column Count = 3 with data in each column
The column width = 1cm; 2cm; 3cm although I have tried various combinations
of width including 0;0;2.5cm
Bound column = 1 but I have tried 2 and 3


Regards

Robert Madden

Do you mean combo box and not a list box?

Check the first column selected in the combo, t can be a field that doesn't
have a value in it (Check the Row source of the combo).

Or, check to which filed the combo is bounded to, also this column might be
blank and this is why no value is shown.


--
Good Luck
BS"D

I have a list box based on a query combining "FirstName" and "Surname" field
bypression within the query - this works when the query is run. (eg Expr1:
Membership.FirstName & " " & [Surname])

It also works on the sub form where the list box resides in so far as when I
click on the drop down the full list of names are shown as combined, however,
when I select a name, the data doesn't fill in the box - just disappears.

Any suggestions would be helpful.

Regards

Juparo

 

[Guest]

It helps if I set up the master/child links correctly.
Thanks for your help

Regards

Juparo

I have a list box based on a query combining "FirstName" and
"Surname" field bypression within the query - this works when the
query is run. (eg Expr1: Membership.FirstName & " " & [Surname])

It also works on the sub form where the list box resides in so far as
when I click on the drop down the full list of names are shown as
combined, however, when I select a name, the data doesn't fill in
the box - just disappears.

Any suggestions would be helpful.

Regards

Juparo

A ListBox doesn't have a "drop down" so I assume you are actually talking
about a ComboBox. Does the ComboBox have more than one column? If so what
are the width settings of the columns?