In which event are you running the code?
Is the BE SQL Server?
Are the master/child link properties set for all the subforms?
Once the form loads, do you want to be able to change the criteria?
In which event are you running the code?
Is the BE SQL Server?
Are the master/child link properties set for all the subforms?
Once the form loads, do you want to be able to change the criteria?
It is standalone access BE db, not SQL server .
You can look back post #18 where I posted simple db, the forms are without any event
When button clicked, the source-object of subform is set as:
Code:
Me.SubFrm.SourceObject = "Frm_FST"
where Frm_FST is the name of a subform
Are the master/child link properties set for all the subforms? No, I did not have any link
btw: I had a chance to test on Access 2019, yes, it surprised me that no crazy flickering like Access 365 (I am running on Access 365)
FYI, a little bit informal and in this case, so wrong.
You just can never tell for sure, so maybe best to not assume. Take that advice or don't - just don't get upset that I gave it, OK?
FYI, a little bit informal and in this case, so wrong.
You just can never tell for sure, so maybe best to not assume. Take that advice or don't - just don't get upset that I gave it, OK?
Yes I did. The only time I got any kind of flicker was the first occasion I clicked the button when there was a slight delay.
Not enough to be irritating though