Addinng data using a form after calculated field

[Edgarr8]

Hello!

ok here is my new dilema....

I have a form comming directly from a table..everything works great I can add or delete rows....well now, i go into the properties and record souce and connect it to another table, to be able to have the necessary information to create a calculated field....once i do that i look at my data and eveyrthing is good...EXCEPT! i cannot add any more data into my first table from that form......

What can I do??

 

[SOS]

You might read this to see what you've done to make your query non-updateable.

 

[Edgarr8]

Thank you Smeghead

But i know that the issue is the calculated field i added, is there any ways i can make it work even with the calculated field?

 

[SOS]

Thank you Smeghead

But i know that the issue is the calculated field i added, is there any ways i can make it work even with the calculated field?

If you need to have the calculation, can't you just use it as a control source of the text box on the form and not include it in the query?

 

[Edgarr8]

well i could, but i need to get information from another table and that table to calculate my field..

in one of my tables I have
A block ID, the APN #, the gross acres and the number of trees in that block
on my other table i have a Block ID, variety, year planted and spacing between trees.

The calculated field is Net Acres, so i need to have the spacings X the number of trees divided by feet in an acre so..

[Spacings]*[Tree Count]/43560

spacing comming from one table and tree cound from another...

and thats the issue on that..

 

[SOS]

So go ahead and link on the other tables and include the fields you need to do the calculations. Just don't have a calculated field - do it at form level.

 

[Edgarr8]

*Clap* *clap* Awesome... thank you..i changed that and added it on the form, then it worked.....

 

[SOS]

*Clap* *clap* Awesome... thank you..i changed that and added it on the form, then it worked.....

Cool - glad you got it sorted.