Form Flickering after set recordsource

[bob fitz]

Seem a great sign for me.
May I know your Access version and opperating system? I might recommend my customer then.

I'm using Access 2019 on windows 10

 

[Babycat]

I'm using Access 2019 on windows 10

Thank you bro, I am running on 365. I will try on other machine, MS version to get a luck

 

[Pat Hartman]

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?

 

[Babycat]

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?

Hi Bro

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:

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)

 

[Deleted member 147267]

Hi Bro

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?

 

[Babycat]

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?

Haha I got it, thank you, I will pay more attention next time

 

[isladogs]

I also get no flicker. Tested on a Win 10 tablet with A365 64-bit

 

[Babycat]

I also get no flicker. Tested on a Win 10 tablet with A365 64-bit

Yeah, my hope. But did you try to click several times? Since the issue happens unpredictable, in my machine its rate is around 6/10

 

[isladogs]

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