Forums

This topic is locked

I dont know why

Posted 11 Jun 2002 22:56:45
1
has voted
11 Jun 2002 22:56:45 Christian Volcko posted:
I dont know why I cant figure this out. I am working on a form that a selection in one listbox needs to effect the selections available on another. I am very new to ultra dev and am getting i bit overwhelmed . I have done some tutorials on detail and master pages but those example seem to just display data entered on a form aftyer it is submitted to the database. All I am trying to do is have a form with the above mentioned features which then sends to a detail page. Can anyone render assistance , even if you define it in broad strokes.

thanks
christian

Replies

Replied 12 Jun 2002 16:54:51
12 Jun 2002 16:54:51 Virginia Older replied:
What Technologies are you using?

If I understand, you need to have a drop down on a form on one page that affects a recordset on another? If this is so, I saw a tutorial saying you would name the form field as "Blah" of the UI

then, on your recordset for the page where the form is submitted to, using the Advance section,
Add a variable by clicking the + symbol. Name it var1
put the 'run time value' at Request.Form("Blah"

and hand code your SQL with a WHERE statement of WHERE "PrimaryID" IN var1
w/ your PrimaryID being whatever yours is.

Hopefully I didn't just make that more confusing. The tutorial was actually about using a recordset to filter another, but in the first part he is getting a variable off of a user choice.

www.chronoworks.com/ud40/tutorial2/index.asp is where I saw it

Good luck,
Va.
Replied 12 Jun 2002 19:48:01
12 Jun 2002 19:48:01 Christian Volcko replied:
Hi,

I am using .asp/vb script. No you didnt make it more confusing <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>. Any info that i get from people who know is a good thing to me . I am very new to the whole thing and some of the concepts are kilin me. But every response i get helps me alot! so thanks for the reply!

Christian

Reply to this topic