Invisible records at list box

[pm4698]

Hello there!

i have table with two fields. The one field is called "Surname" and the other field is called "situation". I have set the "situation" field to be a combo box and can take 2 values: d_n and "e_y".

I created a form which has combo boxes and 2 listboxes. The combo boxes take values from the "surname field " (the user selects on of the surnames). I have written a code so, the values of the listbox will be from the "surname" field but there will be only the surnames - values which have "situation" field = d_n.

I tried something like
SELECT table1.surname FROM table1 WHERE [table1].[situation]="d_n". I run the query and i get for my example 3 records - surnames.

When i check the form to see for results, i see an empty listbox BUT i can highlight by left-clicking at the 3 first rows. i can see no records, but if for example i right click and copy paste to any empty text box in the form i get one of the 3 records. The same happens to the other 2 - invisible rows of the listbox.

Any ideas?

Thanks in advance!

http://www.access-programmers.co.uk/forums/editpost.php?do=editpost&p=933332

 

[pbaldy]

First thing to check would be the Column Count and Column Width properties of the listbox.

 

[pm4698]

ok i just fixed it. I had one column but at the width it had values for two columns. Now its working!

Thank you!

 

[pbaldy]

No problemo, glad we got it sorted out.