|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
||||
|
||||
|
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 |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Picklists |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|