Help with VB code with form

[abz_y2k]

Hi

Am having bit of problem, with the form below.

Everything seem to be working fine but all I wanted it to do is to add up any prices I put down on the extraitem cost and add it to the total cost and work out the profit and soo on.

i have attached the form below

many Thanks

 

[khawar]

You can use the same code as used with previous parts

But try revising your structure and making it normalised by not using part names as field names instead use a single field for part name

This could be accomplished by using a master table which holds your bill no date etc and second one will be detail table i which you enter parts for that specific bill or invoice

 

[abz_y2k]

I jtried that cant seem to get it to work, really frustrated

 

[khawar]

Post the code you are using

 

[abz_y2k]

am using the exact same code u wrote for me earlier just changing the field names only

 

[khawar]

Then there should be no problem for adding the same code for new fields you added

There was an afterupdate event you have to copy for that new field

There was a routine to get totals and display them
-you have to add new field names to that routine

and Thats all

 

[abz_y2k]

You know the first part were you sorted the code out for me. when i put the unit number it it used to generate the prices and do all the total and profit.

but this second part where i have to enter the prices manually then let it add to thew total price and work out the profit. I tried to manipulate the same formula's u gave me earlier but can seem to get it to even add up the figures i type into the total field.

can u please have a look at the database

 

[abz_y2k]

i think i have sorted it out now

 

[abz_y2k]

Hi, another question

I got a field which got drop down menu. how can i change the stayus of the drop down menu to from eg: cancelled to completed by entering digit in another field

Will it it be something like this

if date.text = "" then
status.text = "completed"
end if

 

[khawar]

It could simply be

if [date] = "" then
[status] = "completed"
end if

 

[abz_y2k]

tried that, doesnt seem to change the staus when i enter the date

 

[khawar]

Is this "status" is a combo box or a textbox

 

[abz_y2k]

its a combo box

 

[khawar]

What is the row source

 

[abz_y2k]

"To be booked in for fitting";"Job Completed";"Fitting Booked";"Cancelled"

 

[khawar]

Use this

if [date] = "" then
[status] = "Job completed"
end if

 

[abz_y2k]

i tried that it dont work, maybe am putting the code in the wrong place. am putting it on the field date_AfterUpdate

if [date] = "" then
[status] = "Job completed"
end if

 

[abz_y2k]

heres the sample of the database.

 

[khawar]

i tried that it dont work, maybe am putting the
if [date] = "" then
end if

there is no field named date which one you are referring here if Date=""

 

[khawar]

why dont you use the query to get the status instead of saving it in table