Preventing going on to next record until certain fields are comple

[Guest]

If my Text Box (date format) is filled in, I do not want my Combo Box to be
left blank. If Text Box is left blank, it doesn't matter if Combo Box is
left blank.
If Text Box has been filled in and Combo Box has been left blank, I would
like to prevent the user from going on to the next record until Combo Box has
been filled in. If we can incorporate a warning message that would be great.
I have a table as the record source for the form.
Many thanks
Anne

 

[Jeff Boyce]

Anne

It sounds like you could use the BeforeUpdate event of the form to validate
what's been entered. You may also wish to take a look at the Cycle
property, which you could set to CurrentRecord to prevent the user from
accidentally tabbing to the next record.