Auto Text Box Entry after Move to New Record

[gyli84]

I have a textbox on the form called "Logged By". I have a value on another form [Forms]![Helpdesk Staff Switchboard]![Name] which has the name of the person logged in and I would like for this value to be entered into the "Logged By" field on the "Calls" form when the user has finished logging the current problem and clicks to move to a new record/exits the form.
To ensure that no blank records are created though I also need for the user to only be able to move to a new record/different record or exit the form after certain fields say field1, field2 and field3 have been filled in. Is it possible to do If then statements where there are multiple criteria and if so how would this be applied so that someone could not progress to the next record or be able exit the form until certain fields were filled in?

Thanks!

[This message has been edited by gyli84 (edited 08-17-2001).]

 

[AlanS]

You can probably do all of this in the form's BeforeUpdate event procedure. First, check that all required entries have been made - if not, display a message box and set the Cancel argument to True to cancel the update (and the move to another new record). If the required entries have been made, update any fields you need to, e.g.:

[Logged By] = [Forms]![Helpdesk Staff Switchboard]![Name]