[AccessD] Picklist

Software Design & Solutions Pty Ltd. SDSSoftware at Optusnet.com.au
Thu Jul 31 18:56:18 CDT 2003


BerichtWhy not add an after update event on the called form to update a control on the master form before it is closed? Then you don't have to hide / unhide forms.

Kath
  ----- Original Message ----- 
  From: Michael Brosdorf 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, July 31, 2003 7:38 PM
  Subject: [AccessD] Picklist


  Dear group,

  my application has a whole bunch of master data tables. I want to create a single form that allows me to pick one value from these master tables. So far, I pass OpenArgs to the form specifying from what master data table I want to pick a value. That works fine. The form basically consist of a listbox (to display the content of the specified master data table) , a textfield (to hold the ID of the selected entry), an OK- and a Cancel-Button. The form is opened as a dialog form (meaning it keeps the focus until it is closed).

  Now comes the problem: how do I get the selected value back to the calling form? (When the user clicks OK, the form is closed. So the calling form cannot read the value of the listbox or the textbox.)

  Has anyone done something like that and help me out?

  TIA,

  Michael






------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030801/765b2c98/attachment-0001.html>


More information about the AccessD mailing list