Update data with Button

[karl009]

Hi,

I have a form in Tabular view, this form is based on a query I have added a button to the line of data so when pressed it will update the data in one of the fields.

The field am trying to update has data within it, this field is also used to select the data in the query, what am trying to get the button to do is change the data in that field to something else so it will leave the datasheet view and be passed on to the next person to deal with the data.

An example of the data would be "Finance" and the button would remove finance and input "Sales".

The code I have tried to use is;

Private Sub BackToSales_Click()
Dept = "Sales"
End Sub

I am able to manually update this but it would be good not to have to type sales all the time.

Many Thanks
Karl

 

[pbaldy]

I may be blind, but I don't see what the problem is. Are you getting an error? Or is it the fact that buttons are not visible in datasheet view?