DLOOKUP?

Ok, so I add another field to my user table to store the value, then use DLOOKUP to read that value from the table.

When the value is changed, do i need to do anything in the AFTER UPDATE to write the new value into the table? I'm assuming dlookup will only read the value to the text box, not go back the other way. Thank you

I'm thinking about adding + / - buttons and locking the text field so i could add the code to those buttons instead of an after update event. Either way, i need to be able to write any new values to the table

Just bind it to a Table or Query?

Problem is, I have about 3 different users, its need to show the value based on whos logged in hence the requirement for dlookup.

The form is also bound to a table already so i'd need to do a multi-table query which is frowned upon

Why does the value need writing back then?

(You can join as many tables in a query as you like)

Its number of days worked for the person logged in so...

Person A Logs in and types the value 15
When Person A logs in next day, they'll update it to 16 and so on.

I'm going to give this a try Alex, be right back!

I've used DLookup to get the value and works great. I just need to be able to write it back to the table After_Update
Added in Default Value:
=DLookUp("DaysWorked","UserT","UserID=" & [Text_UserID])

Kevin amazingly provided a SQL code in another post to insert a new record for a different problem. I'm looking for something similar to this but to update an existing record instead

CurrentDb.Execute "INSERT INTO YourTable (YourFieldName) " & _
"VALUES (" & YourComboBox & ")"

To Summarise:

On TEXT_DAYSWORKED After Update
Look at USERT for record that matches the userID from TEXT_USERID
Update the field DAYSWORKED

Thank You

Anyone?

Update Queries

UPDATE CustomerT
SET CustomerName = 'Dan Jackson'
WHERE CustomerID = 1;

Thanks alex!