Recent content by azwildcat4ever

Please have a look at the screenshot file below before u start reading this. what i want to do is limit the "Cost Type" drop down list. The limit on drop down is initiated by Placement Type So if you selected Placement Type = "Consultant", the "Cost Type" should be limited to the following...

wokred thnaks

any suggestions?

i am not sure how to disable a field which is this case is WAges. What data am i checking for. The text insde teh pulldown menu or the actual data being pulled from the cost type table. ?what should be validatiing Cost Type field . Cost type id is pulling cost type for tblCostType. So...

what do u mean by that..what does 'me" do this is how the form looks like i want to disabled Wages if cost type id filed is 4

I have a drop down menu on a form. When it has been updated to a certain value I want some of the field on my form to be disabled. I am thinking it is a afterUpdate event, What would be the code to disable another field on the form would it be something like this If...

Ok i think i figured it out..I deleted the ConsultantCost_ID from tblPlacements and then i placed ConsultantCost in the tblPlacement. on the drop down, I have ConsultantCost looking up tblConsultantCost.. now the problem is the dropdown says 1 and 2 which are offcourse ConsultantCost_ID...

how do u make the sample db? i am new to access sorry :)

can u think any properties or additions to form..ConsultantCost is identified as a double in the ConstultCost table ...it is picking up the ConsultantCost_ID which are bascially two right now..two entries..1 and 2 So my ConsultantCost table looks like this ConsultantCost_ID ConsultantCost...

possible Hey Paul, I know whats the problem its rounding the numbers to 0. FrmPlacements has reference to ConsultantCost_ID however no reference to ConsultantCost

Its not doing anything. I dont think this forum will allow us to post the dbs Here is the code to ConsultantCost_ID Its not picking up the value for it for some reason Private Sub Combo89_AfterUpdate() If Not ((Forms![frmPlacements]![Cost]) = "") Then 'Update gross profit...

Not working..anything else i can try. Thanks this is what i got Forms![frmPlacements]![Gross_Profit_Accrued] = Forms![frmPlacements]![Gross_Profit_Accrued] - (Forms![frmPlacements]![Revenue_Accrued] * Forms![frmPlacements]![ConsultantCost_ID].Column(1)) Basically the "Cost" will be determinde...

I have a form where I have a drop-down menu which when updated , updates another value on the form (Gross Profit) when updated changes So the form looks something like this Revenue [ ] Cost [ ] Drop Drop Menu with choice (0.14, 0.045) Gross Profit [ ] Updated once you Update Cost...