Default Value on a form not working...?

[Kumba1]

I have a data entry form... in it I have a hidden field called "Computer" that is supposed to be the computer the data was entered from... I have a function called "MachineName" that returns the name of the computer... how do I get it, so that when someone enters new information, the field "Computer" automatically has the computer name entered into it... is there any way?

 

[JeffChr]

It could be this simple:

From the BeforeUpdate event for the data entry form build code similar to this:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Computer = MachineName
End Sub

"Me" references the open form
"Computer" references your field, which I assume is the field name of the table bound to the form
"MachineName" is the variable containing the name of the computer (returned from your function)

Hope this helps.

 

[Kumba1]

That definately works... I tried setting an unbound box on the main form, and on formload, the box is set to the results of the function machinename via VB Code, but that doesn't work reliably... so I guess i'll use this till I run into a problem... you know what they say, if it works, and it aint broke, dont fix it Many thanks to you sir...