Recent content by mike60smart

Hi It is best that you start a new thread rather than hijacking this thread.

Hi Your Relationships window should look something like the attached. This allows you to create a Main Form based on People with a Subform based on Levels and Ratings.

If you can see all the tables what do you want to do next?

When you start to add a new record in the subform you will automatically generate a new blank row. This is how a Continuous Form works.

Hi Well the Op said "I have a subform that I am entering records related to the ClientID on the main form."

You will always have a blank row in a Continuous subform

Can you upload a zipped copy of the database?

Hi In design view of the Form, if you Right Click on the Chart and select Properties you can remove the various Elements. See attached screenshot

Can a person register for 1 Course only or do you want them to be able to register for 1 or More Courses??

Hi Your best layout for what you are trying is a Tabbed Subform. See the attached example.

Hi Simon Can you upload a screenshot of your table relationships?

Do each of the users have a copy of the FE on their computers which is then linked to the BE?

I take it you did not bother to look at the Manual on how to set up a questionnaire? This is one of the easiest ways to achieve what you need.

Hi The attached is one of the best examples of a questionnaire, which is what you are trying to achieve.

Hi I have corrected all of the points I had noted previously. I believe I have also updated all of the queries that run your Reports. See if the db now behaves as it should. Note there may be some objects that do not run as expected.