Form Formula help

[aimless54]

Here it is again....the priorities tab has the formula in it now.

 

[rainman89]

first off if u are going to set your control source of a list box to a table in your field u dont need to enter the row source values in....
secondly are they supposed to enter the values into the list box or choose them?
if they are supposed to choose them there should be seperate tables for each entry.... (Maintenance,ad/regulatory etc..) if they are supposed to enter it in the the option shouldnt be in a listbox

 

[aimless54]

first off if u are going to set your control source of a list box to a table in your field u dont need to enter the row source values in....
secondly are they supposed to enter the values into the list box or choose them?
if they are supposed to choose them there should be seperate tables for each entry.... (Maintenance,ad/regulatory etc..) if they are supposed to enter it in the the option shouldnt be in a listbox

They are suppose to choose one, so that the priority listings stay consistant.

 

[aimless54]

On the second part about seperate tables- I had that and a person who was helping me told me to get rid of the extra tables. I do have more categories, but wanted to keep it simple for purposes of the forum

 

[rainman89]

change your properties of the priorty box to
=([List8]+[List10]+[List12])
those are the names of your fields that u are selecting not the other names u had in there

 

[aimless54]

change your properties of the priorty box to
=([List8]+[List10]+[List12])
those are the names of your fields that u are selecting not the other names u had in there

Ok, I will give that a shot!
Thanks

 

[rainman89]

im leaving the office now. i will check on your progress when i get home

 

[aimless54]

Still not working, I just don't know what I am doing wrong. I put in the formula as you suggested and it gave me an error message.

 

[aimless54]

Finally got the formula to work and it calculates each record! Thanks for all the help!!!

 

[rainman89]

Not a problem. glad i could help!