Append Query For Form

[darth sidious]

Hi

I am having a problem with my append query on my student form.

When I add in the details on the form and run the append query it throws back a dialogue box saying Enter parameter value...

I have attached my database and would be gratefull for anny assistance.

Many Thanks


Darth

 

[JHB]

When I add in the details on the form and run the append query it throws back a dialogue box saying Enter parameter value...

Because you've a lot of wrong references, one example is shown below:

Student_exam.[Forms]![StudentForm]![StudentForename]

Correct is:

[Forms]![StudentForm]![StudentForename]

 

[namliam]

Like I said on the other (simular, though definately different thread) you have many more issues than this....

However using an Append query to get data into your table from a form is dubious at best. Worse in your current version you have changed your form to be completely bound to the table Student_exam, but still run an append query to get the data from the form into the table (a second time)

Also using a query to get the Max(studentnumber) +1 and using a DLookup to get that information is creative for sure, but more "conventional" is to use a DMax() directly on the table instead of a DLookup on a query.

And please please, while you are in the starting blocks of this project.... Name convention!!!