Need help with Query Updating from selected combo

[Guest_imported]

I have a problem, I tryed to change Table's cell with a value comming from a form (combo) and I was never able to do it.

I tryed using parameters, but could not set the value for parameter to the one from the combo

So if somebody has solution please help! :0

This is what i was trying to make at first, dont mind on my mistakes (doesnt work anyways ). this is just a "picture" of what I was tryinhg to do..

UPDATE Table1
Set Table1.[forms]![form1]![comb0] = Table1.[forms]![form1]![comb0] / 2;

So, I was trying to get the cell name off a combo so I can devide in any of my 3 colums which I chose from the combo.


Thank you!
Vlad

 

[JoeMiller]

You code should look something like this:

UPDATE Table1
SET tblCustomer.[FieldName] = [FieldName]/[Forms]![form1]![comb0];


Hope that helps!
Joe Miller
joe.miller@flotech.net