get Default value on a Form from Query

[McWhorter]

I have a form set up for data entry. I want one of the numeric fields to have a default value of a field in another query. I've tried to set it in the "properties" box of that field with no luck. I then tried to set it in the "On Load" event of the form. I used the following code.

SIRF_Num = [Next_SIRF_Num]!NEXT

SIRF_Num is the field on the form I want to set.
Next_SIRF_Num is the name of the simple query where the default value is.
NEXT is the field containing the default value.

 

[Rolliee]

I think that you need to open the recordset containing the default value, set the value and close it. I would write the code on an 'on click,' see that it works and then cut and paste to the 'on load.'

Rollie E
rollie@bwsys.net

If you need code for this, email me and I will send it.