Maybe someone can tell me what to do as I'm getting nowhere lately... I have a New Customer entry form with a Data Entry subform that writes certain fields to a table. The New Customer gets issued an "Account Number" which is an autonumber field from another table. Each new customer may have several products assigned to them. Everything seemed to be working just fine until I found out that TEN people will be using the form at the same time trying to enter new customers and get new account numbers (autonumber)! Although this is not really an option at the moment, I thought of locking the form so only one person at a time can use it.(?) Any suggestions? Let me know if you need more information. Thanks, Doreen
------------------------ Yahoo! Groups Sponsor --------------------~--> Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
