Need more info can you show your code and maybe a snap shot of the form?

One thing that usually happens when people have trouble with tempvars when you're getting a value from a field you would need to use tempvars ("user") = username.value.

Username being the name youre using to set the tempvar

Thanks Mr. Juan Cavera and Bill Carver for your replies,

Temvars("User") , its okay and working properly if i make any changes in the main form,
but when i make any change in the subform then it doesn't work.

Abusofian you are making your life and the life of those who are trying to help you difficult. As a student on this forum, you must have heard Richard emphasize the importance of code that is legible. Yours is not. Your buttons don't have names.

You do not indent whatsoever. You should write your code so you can read it easier later, as well as anyone else who is trying to help. You use "me." With field names, which is not necessary. It just makes your code more difficult to read.

Post the design view of both your order table and order detail table.

Abusofian You need to explicitly declare the type for EACH of your variables.

    Dim variable1 As String, variable2 As String, variable3 As Long

Abusofian

The "DataChange" property is not a boolean. It is to specify a macro, event, or function that runs when the form datachange event fires. The main form won't know when the that event fires in the subform unless you have a lot more code that tells it to listen for it.

It might be better to have a public function in your main form that the subform could call in its afterupdate event. This would also help you to clean up your code.