How to code a text box so users have to enter data

[KParn]

I want to force users to enter data in a text box, if not user cannot advance to new record

[twinnyfo]

KParn,

It depends on how the user navigates to the new record. I fyou have a button then in the OnClick event of the button, check to make sure all the data has been entered. You would also have to have the AllowAdditions set to False and make those settings at the same time.

However, you don't describe anything about your DB or your form (or your tables), so it is impossible to give any more detailed response.

If you have tried something so far, please show your work and we can trouble shoot from there. We will not write this code for you.

[stress999]

Twinnyfo I have a form with contacts. First and last names for example. If a user forget to enter last name; then I want the system to kick out a message (please enter last name).user should be unable to advance until msg is satisfied.

[twinnyfo]

@stress999,

Again, it all depends on how the user is to navigate to the next step. If you have a "Next" button, then in that button's OnClick Event, you first validate that there are values in both the First and last Name Text Boxes. If not, then don't allow the form to move to the next step, and set the focus on the Text Box that is missing information.