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

I guess my question is if you would ever need a count of attendees or a list of the meetings John Peterson had attended. There may also need to be a status for each attendee like “no show”, “attended”, “canceled”, or other. Placing all the attendees in a single field is very limiting compared with having an EventAttendee table with fields like:

EventID

AttendeeID

StatusID

LastUpdated

Just my thoughts after having been burned by billowing requirements after table design had been set. 

Duane

On Apr 30, 2026, at 4:00 PM, Dean Waring via groups.io <deanjw2006=msn.com@groups.io> wrote:



Thank you again for your insights. My listboxes allow for users to select individuals who attend meetings. A user can select one or fifty. I do have a table of attendees from which the elections can be made. I am not sure what a better way would be and would appreciate your thoughts. The field is just a textbox.

Dean J. Waring

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Tuesday, April 28, 2026 11:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Returning to a specific record on an access form from another access form

 

Hi Dean,

Glad to hear you got this sorted out.

It looks like you are storing multiple attendee values in a single field. This goes against basic normalization rules. Typically, there would be a related child table that would store one attendee per record. If your current table structure works, then  continue on. I have found these multi-value fields very limiting when considering future functionality.

I like your control named "txtlistresults". You might want to consider changing some other control names in the future to make your application more "self-documented".

Regards,

Duane

---

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

 

Thank you for your reply, and I apologize for my vague problem description. However, I believe that I was able to find a fix based on your questions. Below is some of the code. You may have a better solution. The issue appeared to be that I was re-opening the main form causing it to go to record 1. Here is what I came up with:

Main form, frmOGS, control launches new form with listbox:

 

Private Sub Command6_Click()

DoCmd.OpenForm "frmTDAttend", acNormal

End Sub

 

frmTDAttend listbox:

 

Data source for listbox:  list0= SELECT qryAttendees.[Full Name] FROM qryAttendees;

Multi Select = Simple

 

CmdSelect:

 

Private Sub cmdSelect_Click()

Dim varItem As Variant

    Dim strSelected As String

    Dim ctrl As Control

   

    Set ctrl = Me.List0

   

    If ctrl.ItemsSelected.Count > 0 Then

        For Each varItem In ctrl.ItemsSelected

             strSelected = strSelected & ctrl.ItemData(varItem) & "; " & (Chr(13) + Chr(10))

        Next varItem

       

        ' remove leading comma

      

        strSelected = Left(strSelected, Len(strSelected) - 2)

       

       ' assign value list to hidden text box control

      

       Me.txtlistresults = strSelected

      

       

       

        Debug.Print strSelected

      

    Else

        MsgBox "Noitems selected", vbInformation, "Warning"

    End If

   

    

    DoCmd.OpenForm "frmOGS", acNormal

    [Forms]![frmOGS].[TD Invitees] = strSelected

        DoCmd.Close acForm, "frmTDAttend", acSaveYes

End Sub

 

Dean J. Waring

---

From:  Duane Hookom 
Sent: Sunday, April 26, 2026 10:42 AM
Subject: 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?

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

Thank you again for your insights. My listboxes allow for users to select individuals who attend meetings. A user can select one or fifty. I do have a table of attendees from which the elections can be made. I am not sure what a better way would be and would appreciate your thoughts. The field is just a textbox.

Dean J. Waring

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Tuesday, April 28, 2026 11:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Returning to a specific record on an access form from another access form

 

Hi Dean,

Glad to hear you got this sorted out.

It looks like you are storing multiple attendee values in a single field. This goes against basic normalization rules. Typically, there would be a related child table that would store one attendee per record. If your current table structure works, then  continue on. I have found these multi-value fields very limiting when considering future functionality.

I like your control named "txtlistresults". You might want to consider changing some other control names in the future to make your application more "self-documented".

Regards,

Duane

---

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

 

Thank you for your reply, and I apologize for my vague problem description. However, I believe that I was able to find a fix based on your questions. Below is some of the code. You may have a better solution. The issue appeared to be that I was re-opening the main form causing it to go to record 1. Here is what I came up with:

Main form, frmOGS, control launches new form with listbox:

 

Private Sub Command6_Click()

DoCmd.OpenForm "frmTDAttend", acNormal

End Sub

 

frmTDAttend listbox:

 

Data source for listbox:  list0= SELECT qryAttendees.[Full Name] FROM qryAttendees;

Multi Select = Simple

 

CmdSelect:

 

Private Sub cmdSelect_Click()

Dim varItem As Variant

    Dim strSelected As String

    Dim ctrl As Control

   

    Set ctrl = Me.List0

   

    If ctrl.ItemsSelected.Count > 0 Then

        For Each varItem In ctrl.ItemsSelected

             strSelected = strSelected & ctrl.ItemData(varItem) & "; " & (Chr(13) + Chr(10))

        Next varItem

       

        ' remove leading comma

      

        strSelected = Left(strSelected, Len(strSelected) - 2)

       

       ' assign value list to hidden text box control

      

       Me.txtlistresults = strSelected

      

       

       

        Debug.Print strSelected

      

    Else

        MsgBox "Noitems selected", vbInformation, "Warning"

    End If

   

    

    DoCmd.OpenForm "frmOGS", acNormal

    [Forms]![frmOGS].[TD Invitees] = strSelected

        DoCmd.Close acForm, "frmTDAttend", acSaveYes

End Sub

 

Dean J. Waring

---

From:  Duane Hookom 
Sent: Sunday, April 26, 2026 10:42 AM
Subject: 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?

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

Hi Dean,

Glad to hear you got this sorted out.

It looks like you are storing multiple attendee values in a single field. This goes against basic normalization rules. Typically, there would be a related child table that would store one attendee per record. If your current table structure works, then  continue on. I have found these multi-value fields very limiting when considering future functionality.

I like your control named "txtlistresults". You might want to consider changing some other control names in the future to make your application more "self-documented".

Regards,

Duane

---

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

 

Thank you for your reply, and I apologize for my vague problem description. However, I believe that I was able to find a fix based on your questions. Below is some of the code. You may have a better solution. The issue appeared to be that I was re-opening the main form causing it to go to record 1. Here is what I came up with:

Main form, frmOGS, control launches new form with listbox:

 

Private Sub Command6_Click()

DoCmd.OpenForm "frmTDAttend", acNormal

End Sub

 

frmTDAttend listbox:

 

Data source for listbox:  list0= SELECT qryAttendees.[Full Name] FROM qryAttendees;

Multi Select = Simple

 

CmdSelect:

 

Private Sub cmdSelect_Click()

Dim varItem As Variant

    Dim strSelected As String

    Dim ctrl As Control

   

    Set ctrl = Me.List0

   

    If ctrl.ItemsSelected.Count > 0 Then

        For Each varItem In ctrl.ItemsSelected

             strSelected = strSelected & ctrl.ItemData(varItem) & "; " & (Chr(13) + Chr(10))

        Next varItem

       

        ' remove leading comma

      

        strSelected = Left(strSelected, Len(strSelected) - 2)

       

       ' assign value list to hidden text box control

      

       Me.txtlistresults = strSelected

      

       

       

        Debug.Print strSelected

      

    Else

        MsgBox "Noitems selected", vbInformation, "Warning"

    End If

   

    

    DoCmd.OpenForm "frmOGS", acNormal

    [Forms]![frmOGS].[TD Invitees] = strSelected

        DoCmd.Close acForm, "frmTDAttend", acSaveYes

End Sub

 

Dean J. Waring

---

From:  Duane Hookom 
Sent: Sunday, April 26, 2026 10:42 AM
Subject: 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?

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

Thank you for your reply, and I apologize for my vague problem description. However, I believe that I was able to find a fix based on your questions. Below is some of the code. You may have a better solution. The issue appeared to be that I was re-opening the main form causing it to go to record 1. Here is what I came up with:

Main form, frmOGS, control launches new form with listbox:

 

Private Sub Command6_Click()

DoCmd.OpenForm "frmTDAttend", acNormal

End Sub

 

frmTDAttend listbox:

 

Data source for listbox:  list0= SELECT qryAttendees.[Full Name] FROM qryAttendees;

Multi Select = Simple

 

CmdSelect:

 

Private Sub cmdSelect_Click()

Dim varItem As Variant

    Dim strSelected As String

    Dim ctrl As Control

   

    Set ctrl = Me.List0

   

    If ctrl.ItemsSelected.Count > 0 Then

        For Each varItem In ctrl.ItemsSelected

             strSelected = strSelected & ctrl.ItemData(varItem) & "; " & (Chr(13) + Chr(10))

        Next varItem

       

        ' remove leading comma

      

        strSelected = Left(strSelected, Len(strSelected) - 2)

       

       ' assign value list to hidden text box control

      

       Me.txtlistresults = strSelected

      

       

       

        Debug.Print strSelected

      

    Else

        MsgBox "Noitems selected", vbInformation, "Warning"

    End If

   

    

    DoCmd.OpenForm "frmOGS", acNormal

    [Forms]![frmOGS].[TD Invitees] = strSelected

        DoCmd.Close acForm, "frmTDAttend", acSaveYes

End Sub

 

Dean J. Waring

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Sunday, April 26, 2026 10:42 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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

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

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

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

New Industry Guidelines Detail How to Buy Fabric Online Without Seeing It First

To buy fabric online without seeing it first, buyers must mathematically translate digital specifications like Grams per Square Meter and stretch percentages while enforcing strict physical wash protocols on sample swatches. Leading U.S. textile suppliers reported a 42% decrease in wholesale returns during fiscal 2025 when commercial buyers abandoned subjective texture descriptions in favor of hard data. Digital sourcing removes the physical hand from the evaluation process. The hand defines the tactile feel of the material. You risk severe manufacturing delays if you rely on flat lay photography alone. Source: Linkedin

Buyers determine accurate material density by reading the GSM data rather than trusting generic vendor adjectives. GSM measures exact physical weave density. A 150 GSM textile material performs well for lightweight apparel, whereas a 400 GSM material provides the rigidity needed for commercial outerwear. Digital sourcing requires buyers to locate visual proxies to evaluate drape. Drape defines the hanging behavior of a textile. Buyers assess this fluidity by demanding rosette photographs. A rosette photograph displays the material twisted into a spiral. You misjudge the flexibility of the warp and weft if you only review flat images.

Buyers verify pattern compatibility by extracting the stated stretch percentage and replicating that ratio against a physical ruler using known knit textiles. Spandex fibers dictate the modulus of elasticity. A 4-inch sample possesses a 50% stretch capacity if it extends to 6 inches comfortably. Professionals mitigate remaining physical risks by executing rigorous swatch tests. A swatch test exposes the raw sample to American Association of Textile Chemists and Colorists wash standards. You quantify shrinkage accurately if you launder a precise 4-inch square sample at maximum industrial heat settings.

Safe digital textile sourcing requires strict adherence to standardized numerical metrics over subjective visual estimations. U.S. industry data proves that quantitative analysis eliminates the traditional barriers of remote purchasing. Buyers secure exact materials for bulk production runs if they follow these technical translation methods. Start your next commercial manufacturing run securely by immediately requesting a baseline test sample from your chosen digital supplier today.

--
You received this message because you are subscribed to the Google Groups "Broadcaster" group.
To unsubscribe from this group and stop receiving emails from it, send an email to broadcaster-news+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/broadcaster-news/6d9c8e7b-592c-4df2-99b6-5e59b982d4c1n%40googlegroups.com.