Using Access 2003.
I have a form and a subform.
On the main form, one of the fields is a lost box, which lists line numbers ie 1, 2, 3 etc.
Then the list box is clicked, the subform corresponding to the line number info is shown.
When a new record is added to the subform the new line number is added and is shown in the main form list box.
The list box on the main form gets the focus and the new line number is highlighted.
However the new highlighted line info is not used, but because the list box is requeried the first line info is used to call up the subform, although the new line is highlighted.
When the record in the sub form is created, I want the list box to be requeried and the new record line to be highlighted and the new record to be shown.
I have a form and a subform.
On the main form, one of the fields is a lost box, which lists line numbers ie 1, 2, 3 etc.
Then the list box is clicked, the subform corresponding to the line number info is shown.
When a new record is added to the subform the new line number is added and is shown in the main form list box.
The list box on the main form gets the focus and the new line number is highlighted.
However the new highlighted line info is not used, but because the list box is requeried the first line info is used to call up the subform, although the new line is highlighted.
When the record in the sub form is created, I want the list box to be requeried and the new record line to be highlighted and the new record to be shown.
Comment