Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old December 20th, 2003, 03:02 PM
foln foln is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 1 foln User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Picklists

Hi,
I have a form for linking traders to trade types. This uses a sub-form that has a combo box to let the user choose which trade type(s) the trader is associated with.
I want the user to be able to open a pop-up form from in which they can search for trade types and, if needed, add a new one when they find that they need to. I've got this far!
Now, when they create a new trade type I'd like them to be able to close the pop-up form and have the last trade type they selected, or created, be returned to the sub-form as the new value.
Er, I think that makes a kind of sense?!
At present they can search and create but upon returning to the sub-from they then have to open the combo box and find the new trade type they've jsut created. It does work but I feel it would make for a better interface if it was automatically popualted with the new value.
Many thanks for any help supplied!
Cheers.
Troy

Reply With Quote
  #2  
Old December 23rd, 2003, 08:41 AM
supersubra's Avatar
supersubra supersubra is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Location: Coimbatore, India
Posts: 280 supersubra User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 h 15 m 10 sec
Reputation Power: 6
declare this tradetype variable in one of the general module class


Public gltradetype As String



'Open the popup form with this command
'where fpop is the name of your popup form.
'if it is subform continuous put a command button and pase the following code

DoCmd.OpenForm "fpop"
Do While SysCMD(SYSCMD_GETOBJECTSTATE, acForm, "fpop")
DoEvents
Loop
me!combobox= gltradetype

On Update or save event of the popupform store the value added into public variable gltradetype.
__________________
V.Subramanian

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Picklists


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway