Form for multiple tabels join issue

[LiverEatnJohnson]

Thanks in advance for the help everyone.



I am working on a small database to report on student eval to a motorcycle safety course. Here are my relationsships and fields


What I want to do is have one form that can enter all the data in and it places an entry into several tabels. I have attached a copy of the form the students use, and as you can see the whole databse is built off that form. The end result is to do satistic reporting on that form. Right now I am running into a syntaxk error in join operation that is a bit confusing because it dosen't tell me which join the error is in. My question is can I even use one form to add a new class with coaches, and then another form for each eval that the students fill out to enter the rest of the data. If possible the form should look as much like the one the students see as possible. I want to use one form for the whole database if I can. If anymore information is needed let me know.

Thanks for the help
LiverEatnJohnson

[June7]

Can't use one query and one form to enter data into multiple tables. Use form/subform arrangement.

It is not always practical to make a data entry form look exactly like a paper form but should get it close.

For instance, the form wants user to mark a check in front of a category (__Cruiser, __Touring, __Sport Bike, etc.). On form this could be a Combobox, Listbox, or OptionGroup with radio buttons.

[LiverEatnJohnson]

I agree with you about the combo boxes and how a form looks on paper and access. I have made some progress though, what I am gonna do now is change the relationship between the class and eval to one to one and then the eval becomes the stored form for that class i will then add another set of tabels to hold the answers the studnets give. Then with a little vba i can generate a form from the entries in the eval and related tabels and report on the answers in the student answers tabels. I will post my relationships when i get it and any I code I use to get this working. I belive others will benifit from this project and any help on it would be appchiated.



Thanks

[LiverEatnJohnson]

Here is the new tabel relations




I will post code and other questions as i go. The question for now is how do I attach code to a form, and what kind of functions should i use to generate things like text boxes, option groups, check boxes, and text fields so that they match the entries made in the eval form and its related tabels? Then how to save the filled out form into the answers tabels. Any help would be great Thanks!

[LiverEatnJohnson]

Changed it again to include a table for each type of answer attached to the eval form to make saving the answers and reporting on them easer, like this.

[June7]

Building tables, queries, forms, reports is basic Access functionality. There are wizards to assist or can build manually. Refer to Access Help.

Code can be either macros or VBA. I use only VBA.
http://office.microsoft.com/en-us/ac...010341717.aspx
http://www.access-vba.net/introducti...ccess-vba.html
http://www.functionx.com/vbaccess/Lesson01.htm
http://ms-access-tips.blogspot.com/2...ers-guide.html
http://ms-access-tips.blogspot.com/2...-property.html

[LiverEatnJohnson]

hey

Are reports just really sql select statements?

[June7]

Same as for a form, the RecordSource for a report can be a table or an Access select query object or an SQL select statement.

[LiverEatnJohnson]

Ok this is so crazy.

I am trying to write code that will pop up a dialog where the user will select a class from the class table and then it will load the form so they can enter the evaluation data for the class they selected is there any way to do that i am not finding any help on this in google.

[June7]

Here is one way to filter a form's dataset http://datapigtechnologies.com/flash...tomfilter.html

[LiverEatnJohnson]

Here is one way to filter a form's dataset http://datapigtechnologies.com/flash...tomfilter.html

I am not trying to filter i want a listo box to pop up on form open and ask the user to choose a class once they have the class id is set tell they push chose another class button

[June7]

What do you mean by 'popup'? A MsgBox or InputBox are intrinsic functions that can 'popup' to prompt for user input. Otherwise, have to build your own 'popup' with a form.

What is a 'class button'?

[LiverEatnJohnson]

popup as in a dialog box, sorry that wasn't clear but the dialog box needs to have a list box in it so the user can select the class they want to add evals to.

[June7]

Then that is a form. Passing the selected value from popup back to the main form can be tricky. http://www.tutcity.com/out/access/pa...form.54951.htm