Re: [MSAccessProfessionals] Returning to a specific record on an access form from another access form

I’m not sure what you mean by “launches a list box control”. Are you opening a new form that contains the list box?  Does your main form remain open? Is the new form opened in dialog mode? 

We would need to see some code. It seems like you have a requery in your code that would reset the main form’s position to the first record. 

Duane Hookom 

Sent from my mobile

On Apr 26, 2026, at 8:34 AM, Dean Waring via groups.io <deanjw2006=msn.com@groups.io> wrote:



I have a main form with a control that launches a list box control. The list box is a multi-select box. Once the user selects the required choices, they select a button on the listbox form to execute the selections. The code iterates through the selections and populates a textbox on the listbox form. The textbox assigns the value to a variable that populates the main form correctly; however, when I close the listbox form, it returns to the first record in the main form instead of the record updated. How do I get the listbox form to close and return to the calling record on the main form?

Sent from my Verizon, Samsung Galaxy smartphone
Get Outlook for Android