list box on form position of records

[veale1009]

Form is not sorted. It displays the list box to choose a record from that then use other fields to the form then, the form with chosen record from list box and entered data to add a new record to another table. Sorry if you think this is repeating the issue, but it is only further describing the problem. Not all of us are VIP's and are trying to learn from those with more knowledge.

[Welshgasman]

So upload a sample db that shows the issue, as from what you describe is not normal, and something must be causing it.

Don't be concerned about the VIP status. That just means I have made a good few posts. Hell, you can be expert for quite a small number.

[CarlettoFed]

Attach a sample file to get a real situation of what you have achieved and thus have a chance to help you.

[moke123]

Have you deleted the listbox and re-built it to rule out corruption?

[davegri]

"Form is not sorted. It displays the list box to choose a record from that then use other fields to the form then, the form with chosen record from list box and entered data to add a new record to another table."

If you read that very carefully, I think maybe the form is unbound. I think OP want to click on a row in the listbox and have the listbox columns displayed in separate fields on the form so that they can be edited (you can't edit a listbox). Then he wants that form to update another table.
I don't know why the listbox would have a downward row selected at form load unless code made it so.

We can guess till the cows come home. OP has been asked several times to upload the DB, but...

[CJ_London]

Perhaps the listbox has a default value set

[moke123]

Perhaps the listbox has a default value set

I had the same thought but it's unclear that a value is selected. Often when developing and you close a form and save changes various properties get saved unintentionally.

[veale1009]

Attach a sample file to get a real situation of what you have achieved and thus have a chance to help you.

This is the for to add invoice. As you can see, the list box is not positioned at the first record. I've included the properties of the list box. WWV

[Minty]

It appears to not be positioned at any record, so you probably want it to select the first one.

In the forms load event put in something like:

Me.YourListboxControlNameGoesInHere.Selected(0) = True

Edit: You'll then need to do something to make the form go to the matching record.
Presumably you already have some code to do that when the list box is clicked, so call that routine.