Search results

Could you post the database included some data and the report (+ name of the report), because I don't really want to input/enter some fake data + make a report when you already have it. Remember to "Compact & Repair" it and then zip it then you haven't post 10 post yet!

Sorry - personally I find you code a little "to messy", where it is jumping here and there and back again, trigger some of the build in events like the Current event. You need to find out where you code trigger the Edit command/statement, then it can't be right that the form start up in Edit...

The only way I can see you maybe will be able to get it, is to manipulate the page length by code.

Yes you've created one, you call it Text24, but you're NOT using it, so it really doesn't help. :) Below the code shows how it should look like! DoCmd.OpenForm "frmUpdate", , , "visitID = " & Me.Text24

The problem is that the form is in Edit Mode when you press the button. You can test the above statement by adding the below code: Private Sub cmdNext_Click() 'On Error GoTo Err_Handler: If Me.Dirty Then Me.Undo End If DoCmd.GoToRecord , , acNext ..

No problem - what I mean is the code you had in frmExam, should work but it didn't, therefore I wrote a "little" corrupt. Too much corrupt that your code worked, but not so much corrupt that the form would not open or other errors appeared. The proper way should have been that you included a...

You're welcome. The form frmExam seems to be a "little" corrupt, so ... :)

Are the 11 tables coming from some data in Excel? Have you looked at the Union query? Show some example data in a database or Excel sheet.

Here is the database again.

What is the idea of inserting the data from 11 tables into 1 table?? A way to do that is using a union query!

Put Me! in the front of the code then it works. DoCmd.OpenForm "frmUpdate", , , "visitID = " & Me!visitID

That was one thing but you also need to change: From: Me!fsubFieldDataEditor.Form.SourceObject = strForm To: Me.fsubFieldDataEditor.SourceObject = strForm

Here is the database back. I've added a new "form" which update automatic when the combobox change, the other is corrected to what you wrote you would like to have.

Could you post your database, with some sample data, zip it + the name of the form.

Can't you use the round function? https://www.techonthenet.com/access/functions/numeric/round.php

Do you want to change the data in a form or do you want to change the form showing in the fsubFieldDataEditor container? If data then it is RecordSource instead of SourceObject!

You need to use a crosstab query.

Because there are a lot of wrong code/statements: First take away all the NZ so it isn't disturb you, because it seems that you use the function without thinking, then you can built it up piece by piece.

Is it possible for you to post the database with some sample data, (zip it) and the name of the report?

Post your database with some sample data + name of the form!