Search results

Hi Ken Normaly I would agree But I'm building this aplication to integrate with our accounting Package So I need to save the values so they can be used elsewhere. Thanks Joshker

Hi All I hope some one can come up with a good solution for this. I have a Purchase order with lines in the sub form I've go the correct controls and calculated controls so I can display the totals. However I need to store the totals in the Purchase order table. I have tried several...

Thanks for the reply RoyVidar Yes the query does depend on the record being saved, and thanks to your response every thing is working as it should. Thanks Joshker :D

Problem solved (At a loss please help) I need to have a query run after the record has been saved and only if it is a new record. I've tried afterupdate event on the form but it doesn't run the query. Here is the code I put in the afterupdate event. I'm at a loss :confused: how ever I'm sure...

Boy oh boy do I feel dumb :D The Problem I was having had nothing to do with the Tabs. I was getting the error on controls when Enabled=No So I added a simple If statement to take care of that. Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acOptionGroup, acCheckBox...

I tried it and It worked I'm not sure why I can't get it to work in my database. But for now I'll continue with it as a Audit_Trail1 as I've already got a lot of work done. On another note Has anyone tried using this with tabs it seems it works fine on tab 1 but on tab 2,3,4... If I make a...

I was gettting the same message as Dom Fino and billcute Compile Error: "Invalid Use of property". The Only working solution I could come up with was to rename the function. It's now called Audit_Trail1. It wasn't working in the Database I created but it was working in the sample. So I...