Forms and Subforms Problem

[GinaWhipp]

Okay, see attached...

[desibabu90]

Okay, see attached...

I checked it and it didn't do anything different for me. ..see pic

Also should you add a Requery for Transmission or for Total in the subform?

It also gave me an error when I went to edit the Transmission Value and it required that add [Table1] before [subform1] in the Requery.

[rpeare]

Can't open 2007 files at this current location. Sorry if you upload a 2003 version (just save your database as an older version) I can look

[GinaWhipp]

I didn't open the forms labeled table just the subforms... Let me fix that...

[GinaWhipp]

Here you go...

[rpeare]

Still in access 2007 format and not 2003, sorry, still can't view it.

[GinaWhipp]

@rpeare

Sorry, I was uploading a new sample for the OP not for you. Here's one for you...

[desibabu90]

first of all, I want to thank you guys for the help.

I see that under subform1 the value shows up, but in main form of Table1, it is still showing as #Name.

Do you know why that is happening?

[GinaWhipp]

Are you opening the form named Table1 without opening the form named Table2? If yes, I'll have to use VBA to fix that.

[desibabu90]

Well, I will be opening Table 1, then Table 2, and then go back to Table 1.

[GinaWhipp]

Yep, let me fix that, here you go...

[desibabu90]

Okay thanks. I will look at this tomorrow, as I am not at work. I will let u know what happens.

Thanks for ur help once again!

[GinaWhipp]

No problem... I'll be here!

[rpeare]

The only thing I changed in your database was the requery statement. I haveL

Forms!table1.subform1!installcost.Requery

You have

[Forms]![table1]![subform1].[Form]![FinalTotal].Requery

But they both function as far as I can tell if you have both forms open at the same time.

If you do not want to have both forms open at the same time this is when you'd have to do a dsum or dlookup (or code using database/recordset type arrangment)

I would like to ask though, why are you putting the information from the same table on two different subforms on two different main forms?

Wouldn't it be easier to do the lookup for a specific vehicle then be able to modify any of the fields you're entering on a single form? On a single subform you could break it up visually into your install costs and final costs. At any rate I can't find anything wrong with your database as long as you have both forms open at the same time.

You just have to apply the requery code to each field on form2 so that after an update on any of the fields it will refresh the value in your second form.

I'm going to re-upload your database with an example of putting it all on one form because I don't understand why you would have separate data entry forms in this case. One other thing to consider is that you don't even really need to separate your data into two forms if you will not have more than one set of repairs on the same vehicle. If it is going to be possible to have more than one set of repairs on a single vehicle you will probably need to use an identifier that is NOT just an autonumber field (use the VIN for example)

[desibabu90]

The only thing I changed in your database was the requery statement. I haveL

Forms!table1.subform1!installcost.Requery

You have

[Forms]![table1]![subform1].[Form]![FinalTotal].Requery

But they both function as far as I can tell if you have both forms open at the same time.

If you do not want to have both forms open at the same time this is when you'd have to do a dsum or dlookup (or code using database/recordset type arrangment)

I would like to ask though, why are you putting the information from the same table on two different subforms on two different main forms?

Wouldn't it be easier to do the lookup for a specific vehicle then be able to modify any of the fields you're entering on a single form? On a single subform you could break it up visually into your install costs and final costs. At any rate I can't find anything wrong with your database as long as you have both forms open at the same time.

You just have to apply the requery code to each field on form2 so that after an update on any of the fields it will refresh the value in your second form.

I'm going to re-upload your database with an example of putting it all on one form because I don't understand why you would have separate data entry forms in this case. One other thing to consider is that you don't even really need to separate your data into two forms if you will not have more than one set of repairs on the same vehicle. If it is going to be possible to have more than one set of repairs on a single vehicle you will probably need to use an identifier that is NOT just an autonumber field (use the VIN for example)

hey the database i sent you was a "dumbed down" version of the actual database. I have a lot more fields on both the forms that take up space. once completed these forms will need to be printed so i am also constrained on the size of the paper...i will still look into this matter but that could be done after I finish the project to make it better or something like that...