Update a field value from a msg box

[kalebson]

I have a form that is used to save employee termination dates. I have another form that is used for promotions and job title changes. The current process forces a person to add the Termination Date..then open the other form and change the Job Title End Date. What I would like to do is this..

Enter the Termination and when you click the "Update Record" button I would like it to pop up a msg box that says something like "Enter the Job Title End Date and have them type this in and when you click OK it will update that record.

Can this be done? These dates are not always the same as the Termination date is the "effective" termination date and the Job Title End Date is the last day they actually worked. Else I could do it differently. ANy help would be great. TIA

 

[rjoubert]

You'll need to use the InputBox to prompt the user for the date.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctinputbox.asp

 

[kalebson]

Cool thx.