AutoNumber Help

[socko139]

I was trying to write a piece of code that would help enable me verify someone is entering a WC_ID. What I've created is a tabbed form where WC_ID resides on the first tab. I want to prohibit a user from trying to enter data on another tab without initially entering a WC_ID (This is done by entering any data on the first tab because WC_ID is an autonumber). So for example if the user enters A WC_Name which is found on the first tab, WC_ID goes from autonumber to for example 5 or 7 etc. Then when u go to the other tab, a WC_ID is associated and u can enter any information u would like. I want to make sure if a user is sitting on an autonumber WC_ID on the second or third tab -- and trys to enter any data in a field, an error message comes up and says please enter a WC_Name.

Hope thats clear. Thanks

 

[JCarmic]

I would use the on current event to see if it was a new record and if so, set focus on the first tab and disable the second and third tabs.

You can then use the update event on wc_name to enable them

Hope this helps

John