Add and Subtract

[lead 27]

Hi

I want to make a button which when clicked will bring up a box which the user will enter a number which will then be subtracted from a number in a field.

I have tried an update query however not been able to getting it working.

Any ideas?

 

[Rabbie]

You asked the same question yesterday http://www.access-programmers.co.uk/forums/showthread.php?t=133835 and said that it worked. Why do you ask the same question again today?

 

[lead 27]

The question is slightly different. I no longer want the unbound text box. Instead I want to click the button and have the box appear (as in an update query) so there is only one button and thats it.

I have managed to get an update query to work by doing in the update to box:

qty-[Amount] however this updates every record in the table and I only want the one I am currently on

 

[Rabbie]

That shouldn't be a problem. Just set the criteria of your update query to select the record you want to update. This might need a little coding behind the button before you fire off the query

 

[lead 27]

Dont suppose you might have any idea what the code would be?

 

[Rabbie]

Since I don't know your selection criteria I can't write you code but you just need to create a SQL string that has the update info and a Where clause that finds the record you want to update.