Search results

Oh and here I was thinking I was doing good too!:rolleyes:

thanks for taking a look

do i need to save in older version it is 2007 right now

can anyone offer any suggestions as to why nothing seems to be working...

=[frmCreateInvoiceSUB]![OrderSubtotal] Nope it still gives me a #Name? error

Hum... I changed it to match your post and that didn't work

really.... that is interesting because I used the expression builder for that part.... I would have thought that the builder would have gotten it right....

I have spent much of today trying to create a subtotal in a subform then displaying it in my main form I have tried almost every suggestion on here and I keep getting a name error on the main form... I know the reference is spelled correctly in my subform I have in the form footer a textbox...

I have spent a while searching this issue on here and it has led to additional questions... Is it better to calculate the tax per item or on the entire order? :confused: I understand that because the tax rate can change that this calculation is justifiably stored but that leads to my next...

Ok because nothing is being passed to tblOrderDetails.... I'll keep working at it... Oh that would be great... I'll keep plugging away on what I have... take your time you have already be most helpful, and I thank you!

Howdy y'all! Nice to meet ya!

I'm also some what of a newbie but I was thinking... Do you Have to have individual records of each Stock-In item? Because you might be able to just do something along the lines of adding to the current stock level via tblPurchaseOrders or something. But if you absolutly must have a record for...

How do I store a calculated field I know it generally is a no no...

ok so do I need to store the tax amount in the tblOrderDetails or would I just recalculate it for frmRecordPymt?

yes that was exactly what I wanted for the subform! Thank You So Much!!!!!! I'm on to the next part...

nope nevermind I can't get it to show in the form... I don't understand how to incoporate the query you provided into the sql of the form

oh hang I i think i got it....

i still can't get the sales tax to work

At this point I have no need to keep record of the bids and I don't really think I will ever have a need fo that in this database simply because my current auction software basically does that

I can't figure out how to do the sales tax calucation...