setting a textbox to DMax and still having it work as an input

simeon_rose

Registered User.
Local time
Today, 09:42
Joined
Nov 4, 2000
Messages
34
hi, i have a form and on it is a textbox that has its control source set to the Dmax function. it is the only textbox that i don't want the user to be able to use and so i have set it so that the user has no control over what is displayed in it. however, because its control source is now set to the DMax function, it doesn't seem to be linked to the field in the table to which the form is linked anymore. this means that although the textbox outputs the correct information from a different table, it no loger inputs what is shown in it to the table. can somebody help me with this?
 
Place the DMax function into the txtbox's Default property, then set the Bound property to the field in the table where you want the info to be stored. Make sure you set the Enabled property to "False" and the Locked property to "True" to keep the user from altering the value.

HTH
RDH
 
this doesn't seem to work. although the textbox is again bound to the correct field, the DMax function no longer generates the desired output. the box only ever has a 0 in it. is there somewhere else i can put the funtion that will make it work?
 

Users who are viewing this thread

Back
Top Bottom