Recent content by TammyT

Nope - didn't work.

Okay, crazy! I just went back & typed it fresh, instead of inserting the Nz - now it took! Go figure. Anyway - still getting the error

Sorry - I did that, just forgot to type them here

1 & 2 - yeah, I can see that would work 3 - it doesn't like the syntax!! When I try =Sum(Nz(Amount)) It says invalid syntax I tried +Sum(Nz(Amount) Same result. Wierd!

Okay, let's see if I can do all the answers at once! 1) Datasheet view - needed to get the new lines 2) Continuous form - I see, they do add; however, that would make for a very loooong sub-form, or am I just tired? I can format so that each new form is really close, right? Either way - I tried...

Oh - no, that won't work, as I need it to add lines as they go, so datasheet view is needed. If you look in the Northwinds Db, they do use the same thing I'm doing (that's where I got it from!), & the sub-form is datasheet view, but does have totals on it's footer that are referred to in the...

If you format as a continuous form, how do you than also format as datasheet? Also - when I just did it as a form, the form footer field for the total gave me an error, instead of showing $0.

Sorry - forgot to include that I had to build the sub-form off of the updates table, not a query, as when I used the query I couldn't type in any of the fields on the form - ???

Form has only 3 fields in the detail - type, date & amount. It's used as a sub-form on another form, to record account transactions for various funds. The sub-form is set to display in datasheet view, so on the main form they can add as many lines as needed, & always see the previous...

There must be a way to do a calculation & then store the result - that's really all I need to do.

Okay - form is based on a table & sub-table. Main table has the account starting & current balances. Sub table has the update records. Main table is for funding sources that have money coming in & going out, so I created the sub-table to record the transactions. I did an auto-form, so that...

Oh - sorry - yeah, that did it! Thanks.

Thanks, AceMan!! Yeah, I knew that! Zor - I've done that as well, but wouldn't apply for this need. I did use it earlier, though, for the simple "pick a name in the drop-down & go to that record" option!

Okay, sorry to bug y'all with this one, but my "cheat sheets" are on a CD at work, & I'm at home! Simple question: On a form, once the data is entered, users need to choose between "Done" (okay, I can handle that one!) and "Add Another Item". On the add another - I need the code for saving the...

That didn't pull anything into the form. Next idea? ! (code - gotta love it!)