R
rbeach
I have a form that opens with information already in filled into all of the
text boxes. The information is either from another form or defaulted into the
text boxes.
Example: The "AcctNum" is from the "NewAcct" Form. The "ReqDate" is default
"Date()". The "Status" Field is defaulted as "UnderReview".
This information only needs to be reviewed and then the form closed. With
this in mind all textboxes are locked.
When the form is closed, I want a new record saved in the table that the
form references which would be "AccountStatus".
Problem: If the date is entered manually I can create the record. With all
the textboxes locked I cannot do this. (The record is never concidered
dirty). I have tried the "On Close" acCmdSaveRecord but it does not create
the record in the table. I do not recieve any errors, but the record does not
exist.
text boxes. The information is either from another form or defaulted into the
text boxes.
Example: The "AcctNum" is from the "NewAcct" Form. The "ReqDate" is default
"Date()". The "Status" Field is defaulted as "UnderReview".
This information only needs to be reviewed and then the form closed. With
this in mind all textboxes are locked.
When the form is closed, I want a new record saved in the table that the
form references which would be "AccountStatus".
Problem: If the date is entered manually I can create the record. With all
the textboxes locked I cannot do this. (The record is never concidered
dirty). I have tried the "On Close" acCmdSaveRecord but it does not create
the record in the table. I do not recieve any errors, but the record does not
exist.