Multiplication of txt box to table field

[veereshrk]

HI guys,

I m doing one project on the access and i have stuck at point plz do help me with this,

I have a form in which i have taken a txt box to add any value in it and then i have used a command button, This command button once pressed then it should multiply the value typed in txt box with the whole field present in one query,

This query field which is to be multiplied contains only one field there are no other fields in it, The field contains several rows with some values in it, the multiplication should be done to all the values,

I am trying to write the code for this,,,,,,
plz help me with this guys,

[goodguy]

Currentdb.Execute "UPDATE tblTarget SET fldTarget = fldTarget * " & txtSourceTextBox

[veereshrk]

Currentdb.Execute "UPDATE tblTarget SET fldTarget = fldTarget * " & txtSourceTextBox

Wel the code seems like understandable to me,,,,, but i even want to know how to make table or query as a currentdb

[goodguy]

I am not able to mke sense of your request.