Re: How do I create a subform programmatically?

Hi John - Thanks for your interest! As you can tell I'm very new to Access
(work on AS400) but am OK with relational databases. I have a search 'Form'
containing 3 combos: Company, Job and Person. Users can select an entry from
any *one* of these and depending on which of them is selected a different
Form/SubForm combination is required. I'm using a stored Procedure to select
the appropriate records to display in each case. It's also important that the
'Search' screen (with the 3 combos) be available and visible throughout the
session.
I can correctly set the parameterfor the stored procedure but i'm not sure
how to associate this with the Form/Subform
Thanks,
jim
"John Vinson" wrote:

> On Fri, 8 Apr 2005 07:09:02 -0700, Jim Scarlett
> <JimScarlett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >I need to create a sub form in code - depending on data displayed in my main
> >form. I'm new to Access and VB
>
> Why?
>
> Normally you would have a pretty much static set of forms; the data
> displayed in the forms will vary, but creating new forms and new
> controls is complex, time-consuming, and usually unnecessary.
>
> What would be the purpose of this new subform? Can you instead have
> subforms already created, perhaps on the pages of a Tab control?
> What's the context?
>
> John W. Vinson[MVP]
>
.

Relevant Pages

  • Re: Cobol Myth Busters
    ... ON SIZE ERROR phrase is used. ... access to tables of fixed size, and so should be avoided where high performance is needed. ... 05 depending-element occurs 1 to 4096 depending on binary-number. ... Packed is almost as slow as display. ...
    (comp.lang.cobol)
  • Re: Order by not working
    ... Depending on which link I click on it's either ... altering as I've added a line to print the query to the screen to make sure ... All I can say is on one server the data is displayed ... Where on the other server where ORDER BY 'count' could display the order in ...
    (comp.lang.php)
  • Re: A list box that changes what HTML is displayed.
    ... I would like to be able to have an HTML form where there is a list ... And the fact that you're even asking shows that you don't really understand how PHP works. ... If you only want to, let's say, display different invoice options depending on the answer to "Personal / Enterprise", you can load everything and use JavaScript to change the "display" CSS attribute. ...
    (comp.lang.php)
  • Re: Dependant combos on continuous form show same value
    ... I have a form with 2 combos; second combo value list depends on the ... But I want to display data in datasheet view, ... Me.NameOfCombo.RowSource = "SELECT MyID, MyName FROM MyTable" ... comboboxes if you need more explicit help. ...
    (microsoft.public.access.forms)
  • Oddities of Tkinter
    ... I am building a tkinter program. ... from an incoming interface, and depending on the data, will display a ...
    (comp.lang.python)
Loading