Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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 August 11th, 2005, 09:30 AM
Authorized User
 
Join Date: Jun 2003
Location: Bromsgrove, Worcestershire, United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes

And I want it to display the RoleName in the field, and when you add another Role, clicking on the cell shows a dropdown with the Roles in it. (Now to be clever it would be nice to have those roles already assigned, excluded from the list:-))
 
Old August 11th, 2005, 09:36 AM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

dude... i think you should VBA this... I have had instance where i used subforms to show attributes of an entity... the way i added additional attributes was using VBA to copy the ID value in the main form to the ID value field in the subform... I belive i used the BeforeUpdate event (i may be wrong)... do you have any clue as to how to go about doing this?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
 
Old August 11th, 2005, 10:02 AM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

quick try..... have you tried to set the 'default value' property of the idUser textbox (you should have this, even if you have to hide it) to the idUser on the main form. ei. Forms![MainForm]![idUser]

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
 
Old August 11th, 2005, 10:19 AM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

dude... i kind of replicated your database and form... my previous suggestion seems to work just fine, and you don't need any vba... what's ur status?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
 
Old August 12th, 2005, 02:36 AM
Authorized User
 
Join Date: Jun 2003
Location: Bromsgrove, Worcestershire, United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

Well I think I got it working, I dragged & dropped the table onto my main form and let Access figure the links, and edited the subform that was created to give me the dropdowns, but not 100% sure on what I did.

I have another subform now for courses the user has been on, so hopefully things will gell then.

Thanks for your help.

Andy




Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigating data in a subform Bob Pierce Access VBA 2 February 1st, 2007 10:58 AM
count data from subform Vince_421 Access 1 May 27th, 2006 11:51 AM
Subform not displaying data hikinfool Access 8 February 24th, 2006 06:11 PM
subform data in report exhibitor Access 4 May 16th, 2005 12:19 PM
Display data in a subform marcin2k Access VBA 1 March 1st, 2005 04:37 PM





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