Search results

Arnelgp: No the Prod_Desc must also be stored at the time of issuing of the purchase order. In case the description should change in the future for whatever reason. If there is a dispute regarding the PO, the exact text desc must retained. I have tried to add code to my AfterUpdate event on the...

Thanks for the replies people. I do realize I am storing the data twice, but I need to keep record of what was ordered 'at the time as product descriptions can change, and I also want the user to be able to add a note that might be relevant to that specific order "Red caps only" or something...

Hello. I have used the following code as the default value for my subform field "Product_Desc": =DLookUp(" [Supplies]![Product_Desc] "," [Supplies] ",[Supplies]![TP_Prod_Code ]=[TP_Prod_Code]) To put it into words, I would like the default value for my subform field Product_Desc to be the...

Thanks for the input all. Form is working. In the end we are talking about choosing a vendor and maybe 2 products. Theory vs practice. Normal procedure as a buyer is to, choose your vendor, then choose your products. It is the rational process.

MajP, good point. I will delete the detail records. I was planning to use an AfterUpdate on the Vendor_ID but... If the user simply clicks the dropdown, but doesnt change the Vendor will it trigger the event? How would I target all the records on the subform for deletion after a vendor change?

Update! I bring good tidings! DBbadguy, changed the requery as you stated and it works fine. Thanks! Step one, DONE ( I thought the "Me." would be enough to make it specify the control that was being focused upon, but I guess that is not how it works:D) Since we never have more than 4 items on...

Thanks for the input people. After reading the suggestions my plans was to: 1) put a Me.Requery on the Product Code combo 2) null all the values on all product codes on the subform in the Vendor ID combo was changed (OnDirty?) So I am stuck on step one:( The result of the Me.Requery is that the...

First post! I have read similar threads with a question close to mine, yet still unable to solve this challenge :( I have attached an image of my form. I have a purchase order form and a PO details form within. When the user selects a Vendor from the VendorIDcombo, the combo box in the subform...