Recent content by krissy21

I just got a whole new perspective on how those particular properties work that I hadn't ever realized! It refers to the records and not so much what the form can do. I can't thank you enough for helping to clear up my subform issue! And I'd forgotten to remove that other OnChange sub, thank you.

Pat, that was a helpful read but doesn't fix my issue. Please see the database attached.

I had an AfterUpdate event also but it didn't seem to work by itself so that's why the OnChange. I have removed it now like you suggested and it still works the way I had intended it to but the problem still remains that the mainform refreshes and clears the subform when the combobox selection...

I have an order form in which I select parts/items from a listbox (lstItemsPerVendor), relating to a specific Vendor, to be ordered and then adjust the quantity and purchase price in the subform (frmOrderItemsPerID). However, I have also made the form allow for specific categories of parts to...

Oh, I see. I had thought that by making those bound to the query, it wouldn't pull the correct information or only the first entry. Thank you, thank you! I learned a lot just now. :-) Krissy

Wonderful! Thank you arnelgp! However, if I enter a Qty for Item #1 and another for item #2, it changes the Qty for Item #1 to what I entered for #2. The same goes for the column PurchasePrice. What do you suggest I should do there?

Hello Everyone! I'm not very proficient at Access but love it's capabilities. I've tried a few avenues but I think I'm making it harder than it may have to be. I have a main order form to purchase items from various vendors and the OrderID is auto-populated. A person may choose a vendor and...

Wow! You are right JHB!! 1. I suppose that makes sense and I should've realized that. 2. Thought I'd set the fields to be the same. 3-5. Did some research and now I understand the reasons why that's useful. 6. I know now why those settings are there and how to use them. Thank you so much for...

Try this attachment......

JHB, I don't know any other way to post it. Did you click the down-arrow in the top right corner?

https://drive.google.com/open?id=0B6jZXGf3QPC1OHd6UUc4MFROdzQ Start the form "Add New Training", enter 1 into the CodeSecNum combo box, write "Test" in the description, and select 1 or more positions from the listbox to apply the training to. Click "Save and Add Training" and close the form...

The [CodeID] is numeric and I tried without the brackets. It didn't work. Thanks for the idea though!! The_Doc_Man, I've tried several more ways including what you suggested and still not giving me anything. Sometimes it won't enter any information into the table I want. Is there something...

I'll go ahead and try the (Count) idea though I'm not sure what you mean by (0 TO ....ListCount-1). Beginning coder. Would you mind writing out the whole line so i understand what it is you mean? The ('before values...etc) was more of a mental note that I forgot to delete prior to posting...

JHB, It was under the combobox event but you gave me another idea. I placed the same event as the OnChange, under AfterUpdate and it works great! :-) Thank you!!!

Hello, I have a combo box on a form that, (OnChange), is set to re-query textbox calculations. When I select an option from the combo box list, the calculations are re-queried as desired. However, when I type them in, nothing happens and the values in the textboxes stay the same. Why is...