So I have a list on my form that has data and the date the data was created (i.e. 12345, 2/1/2020). I want to select the date field and save it in a form field but I also want the data field saved at the same time.
As an example when I click on 2/1/2020 I want it saved into a form field called...
Okay I resolved this and it was much easier than I thought.
On the Main Form "Current" event field I just added a Macro in Macro Builder that refreshes the Form.
Okay I assume its on the main form "Current" event and the code should be
Private Sub List99_AfterUpdate()
Me.lstList99.Requery
End Sub
Where List99 is the name of the List box.
I have a list Box on a main form that shows lines of data related to the main form. When I select next record the Main Form changes as expected but the List Bix does not update to show the data related to record 2. I have tried using
Private Sub MyCombo_AfterUpdate()
Me.lstMyListBox.Requery
End...