list box on form position of records

[veale1009]

I have a form that includes a list box and it is doing all that I want but when the form is displayed, the list box displays all the records and the first record is selected BUT, the first record is not shown. The list box has a scroll bar and it displays many records down and I have to scroll up to get to the first record. I have tried to find a solution but all I can find is how to SELECT the first record. I would just like the text box to show the list starting at the first record from the table. Seems simple but I can't find a solution. Thanks

[Micron]

the first record is selected BUT, the first record is not shown.

I can't see how the first record can be selected and at the same time, not be shown. First thought is to requery the listbox when the form is opened, but that seems like a shot in the dark to me. Perhaps you will get a much faster solution if you post a zipped db copy - see how to attach files at the top of this page. If you wish to try pics instead first, the process is basically the same as posting a db copy because you can't paste pics in a post at this site.

[moke123]

Is the list box bound to the form? Does the sort order of the form and list box match? That will cause this behavior.

I never use bound list boxes. If this is part of a find first procedure use an unbound list box.

[veale1009]

I have a form that includes a list box and it is doing all that I want but when the form is displayed, the list box displays all the records and the first record is selected BUT, the first record is not shown. The list box has a scroll bar and it displays many records down and I have to scroll up to get to the first record. I have tried to find a solution but all I can find is how to SELECT the first record. I would just like the text box to show the list starting at the first record from the table. Seems simple but I can't find a solution. Thanks

[veale1009]

[Welshgasman]

Set the listbox to it's itemdata(0) in the Load of the form.
No idea why it is doing this, I tested with enough records to get a scrollbar and the first was still visible?

I would go with the bound theory.

[veale1009]

This is what's on the form. The list box data is not positioned to first record. I would like it to be positioned to first record. Sorry for posting procedures as I'm new to this. WWV

[Welshgasman]

You cannot just paste pictures on this site. Preview what you post. You need to upload as an attachment.

[Micron]

Obviously my post about pasting pics was of no use.

[davegri]

To get the listbox and the form to be in sync when the form loads, the sort order for the listbox rowsource must match the sort order of the form recordsource.
Attached DB also has a combobox to do the lookup for the form.

veale-davegri-v01.zip

[veale1009]

The form is used to enter data into the customer table. The form is only used to to update fields based on the record selection from the the list box (which shows all fields). I may have mis spoke that the first record was selected. The form is not sorted, and the list box is sorted based on the RowSource requirements:
SELECT [Customers].[ID], [Customers].[CUSTORDCLOSD], [Customers].[First Name], [Customers].[Last Name] FROM Customers ORDER BY [ID] DESC;
Again, the problem is that the list box displays all the records but, it does not display from the first record. I have to scroll up to get to first record. How do I get it to display the record positioned at the first record. Another new question, is there a way to show in the list box only those records that [CUSTORDCLOSD] IS NO, THIS IS A YES/NO FIELD. Thanks WWV

[Welshgasman]

is there a way to show in the list box only those records that [CUSTORDCLOSD] IS NO, THIS IS A YES/NO FIELD

Yes, you use that as criteria for the listbox source.

[Welshgasman]

Again, the problem is that the list box displays all the records but, it does not display from the first record.

Repeating the issue, is not helping anyone.

Is the listbox bound?, sounds like it is.
I gave you a workaround in post #6, however if the listbox is bound, that is going to change your data in that record.

[veale1009]

Repeating the issue, is not helping anyone.

Is the listbox bound?, sounds like it is.
I gave you a workaround in post #6, however if the listbox is bound, that is going to change your data in that record.

Listbox unbound.

[Welshgasman]

Listbox unbound.

So if the listbox is unbound, I cannot see how you cannot be on the first item, unless some code is interfering with the selected entry.
Upload a sample that DB that shows the issue, otherwise we could be here forever.