Hello,
This is a question that has been asked before but for some reason when I am trying to set it up in my lease management database it does not work like I want it to.
I have a subform (in a datasheet format) on a main form that are using the same table as a data source. All the fields in both forms match. When I click on the line in my subform datasheet, I would like the data to change in the main form to reflect what has been clicked in the main form. Essentially, the subform and the main form would act as a split form.
I found similar threads that used this as a Current Event :
Code:
Private Sub Form_Current()
Me.Parent.Filter = "BaseAnnualRent= " & Me.BaseAnnualRent
Me.Parent.FilterOn = True
End Sub
.
I used the BaseAnnualRent field because it it the one that is unique to in the different data entry lines. What happens when is that when I select, it does what I want it to do. The subform entry shows in the main form, but every other subform entry disappears. The subform is essentially blank save for the possibility to add an entry. I would like the subform to remain the same after clicking.