Search results

OK, I see now that it wasn't so ugly as I'd thought. It wasn't a calculation error or bad syntax in my queries or whatever awful thing I thought. It was my poor naming scheme. In the main form. Something was looping because some form text boxes had the same name as table fields. Changing the...

Now I feel like I'm really imposing on you. Whenever my subform has any records, whether created standalone or within the parent form, and I close the main form and then reopen it, I get the following big ol' error and a white blank spot on the main form, where the subform ought to be: "This...

That worked, Scott! Now, being the kind of person I am, I want to know why THAT worked and not any of the other syntaxes we tried. Do you know? Creating my bogus form the other day, other syntax worked. Is it my version of Access? Is it the context? Is it the operating system I'm developing in...

Can't be a record with a problem, Scott, since I'm just creating a few on-the-fly as I'm testing, and deleting them again. I'll post the database, thanks. The table and form I'm dealing with are tblPurchased_Items frmPurchased_Items. My intention is to use frmPurchased_Items as a subform. Hope...

OK, tried that, too, Scott.... =Sum(Me!txtItem_Cost*Me!txtQuantity) and =Sum([txtItem_Cost]*[txtQuantity]) both return #error. Access puts the square brackets in, itself. I'm stumped, not that that's a big surprise.... it OUGHT to work, right? It's the same syntax I used in the junk form...

Scott - Thanks (again) for assistance. I've made the exact changes you suggested (via copy and paste), including going back to having Control Source for txtExtended_Price being the calculation instead of using the AfterUpdate event, but am still getting #error in the sub total box. Access...

I have a simple tabular form with the following: cboItem_Name txtItem_Cost txtQuantity txtExtended_Price The AfterUpdate for txtQuantity = Me!txtExtended_Price = Me!txtItem_Cost*Me!txtQuantity, which puts the extended price in the control. In the FOOTER of the form, I have txtSub_Total. It's...

Simple form - totalling error STILL Thanks, Iago, but so far I'm just looking at the tabular form on it's own, outside the main form. From what I've read, in my reference book, here on the forum and in looking at the Northwinds sample, putting =SUM(fieldname) in the footer of the form ought to...

I am making a simple tabular form to use as a subform in another. The form has a cbo box (cboItem_Name) Quantity (txtQuantity) Price (txtItem_Cost) Extended Price (txtExtended_Price) Selecting an item in the combo puts the price in txtItem_Cost. Default for Quantity is 1. Control Source for...

Me neither, Scott. If there exists a test record when I place the subform, I get a massive choke telling me I'm trying to do coding that's too complex, and only get a big white box in the middle of the parent form. Using the same flavor code to display my combo box and place the price in the...

Thanks, Scott. I appreciate all the explanations and the time they've taken. I am looking into the Northwind samples. I've stabbed at subforms since my last post and gotten more errors than, well... than I'd like. The really unhelpful ones, too. Rather than leaning on you more, right now...

Scott - I do have other questions regarding the new table you're suggesting. I already have Unit Cost field in the table of items and I have quantity, now, in Transactions. ItemID and TransactionID already exist in their tables. Isn't my Transactions table doing the job of this new table? I...

Thanks, Scott... All that is very helpful. I note you said "Deleting the Controlsource eliminates the mismatch, but also eliminates the value being stored in your table." This sounds like a bad thing. If Control Source is where the data is stored, (and why not use an intuitive term for this...

Never mind.... I've learned that I'd totally misunderstood the function of "Control Source" and having that set the way I did was the problem. Leaving it blank lets everything work.

Scott - I am confused, for various reasons. My combo Therapy_Type is bound to the Therapy_ID field. (bound column = 1) The Control Source is Therapy_Cost, but that's the field the price pops up in. Now that I think about it, I had Control Source set that way prior to using the AfterUpdate...

Ken, thanks. I've changed my bound column to every option. Sometimes I don't get the price populating, sometimes I don't see my combo selection and sometimes I get a big fat error. No option works correctly when all I change is the bound column. It's gotta be something in the AfterUpdate....

I have a combo box set up to select a product and put the price into a text box. I am getting the cost showing up in the text box Therapy_Cost just fine, but the combo box itself does not display anything after I select something. If I remove the AfterUpdate, I do get the item displaying in the...

Scott - The colors are fine. I did check them, but when I remove the AfterUpdate, the text shows just as it should. I also made the column changes you suggested and that did no good either, other than slightly cleaning up the programming. I'm attaching the database without the column changes...

Scott - Let me say "DUH", since I KNEW that the columns start with zero... So I've changed the AfterUpdate VB code and I'm apparently getting the $ values I want in my text box, but my combo box is still coming up blank, no matter what item I pick, so I'm not sure if it's defaulting to the...

Scott - Thanks for the help. I can see how this is supposed to work. The bound column is set to the unique identifier and the After Update is supposed to tell the text box to reflect the price column. Unfortunately, when I do this, it doesn't work. With no AfterUpdate event, I always get the...