Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 30th, 2006, 09:01 AM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default avoid dublicate values

Hi, again
I have a main form with a field named LastNameand a subform with a field LastName, too!
My problem is that when I'm typing a last name in main form to not accept the same name to type in the subform!

Thank you, very much
Vision G

 
Old June 30th, 2006, 10:04 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Could you share any more information on this? Such as what are you looking for, and what function does the subform server in relation to the main form.

Thanks

Mike

Mike
EchoVue.com
 
Old June 30th, 2006, 12:18 PM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default

Look!
In the main form I'm writing the last name of a manager of a company e.g. Scot
This main form has a subform with a field last name too!In this subform I want not leaving me to write the name Scot (despite the fact there can be many Scot!
I hope I made you clear Mike!
Thank you!

 
Old June 30th, 2006, 12:24 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Ok, so your type Scot in, and you want it it appear in the subform as well.
The key thing here is how your subform relates to your main form. Does it contain a list of all companies, and you are using the main form to enter a new company?

If this is the case, you want to ensure that the field on your subform is bound to the same data source as the one in the main form. If it doesn't populate right away, you may need to do a requery on your subform.

Like I said the key thing, is how does the subform relate to the main form. Typically you would want to avoid duplicate data having to be entered or displayed.

HTH

Mike

Mike
EchoVue.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to avoid duplicate values from the xml file us balasundarrao XSLT 2 June 4th, 2014 11:56 PM
How Do I avoid duplicate values xsltier XSLT 3 June 4th, 2008 01:36 PM
how to avoid logon justin_min Crystal Reports 0 November 30th, 2004 02:05 PM
Avoid duplicate node values nambati XSLT 1 September 8th, 2004 02:41 PM
How do I Avoid a ROLLBACK when... wmhhodson SQL Server 2000 1 October 31st, 2003 01:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.