Avatar of yasanthax
yasanthaxFlag for United Kingdom of Great Britain and Northern Ireland asked on

Having problem setting up a access quentionnaire database example

I am creating a simple survey/questonnaire datbase.
Usersrequired a dunamic setup do they can add/remove  questions going forward.

I dedided to create most of the survey at row level of table. I created a table for initial  question types and then an attributes table separately but works on the same   split form.   I have now an issue with the row source coming as the rows source is very slow and is  not working consistently.  the screen values flicker and I thought of setting the attributes table as bound.  Is there an example ofhow to make this form work?  Would a function work more effectively to ensure correct recordsets are returnes and can be veiwed?



Thanks
* Forms APIMicrosoft AccessVBA

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
PatHartman

I presume you've tried compact and repair.

Flickering is a sign of a loop caused by code or perhaps a timer event.  Although the form may in fact be corrupt.  If there is no sensitive data in the database, you might want to compact it and zip it before uploading.
John Tsioumpris

As you said probably is a simple form so you shouldn't have these issues...maybe something in the code is constantly performing requery thus causing slowness and flickering.
Maybe you should take a look at code behind for .Requery, .Repaint and so on.
If not upload a sample here to take a look.
ASKER
yasanthax

I have a table with the
- condition identifier
- In the dropdown combo , I am returning the value of the conditional identifier  to an oncurrent functon

As soon as I select the combo box it shows the valid values as expected, However  if I leav ethe field the value is no longer seen althought it is there.   I tried looking up the table value to the orininal Id and text, still the same issue.

Do I need to use a tabporary table, and not sure it that helps.  When do you need to create temporary tables in MC Access datbases?

Thanks
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
PatHartman

We are only guessing at the problem if we can't see all the code behind the form.  Your code is causing the problem so we need to see it.
ASKER CERTIFIED SOLUTION
yasanthax

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
PatHartman

Sounds like lots of extra, unnecessary code but as long as you are happy, we're happy.