DBR Form

[MaureenKLM]

RE: FP2003 with Access 2002 DB

I want to create a form using DBR to provide a dropdown list for Visitor to
select from (DBR1), plus add additional fields - this form submits to the DB
- all works here (this form would submit results to a DB table)

Tricky part for me is that I also want this same form to be the criteria for
displaying a second DBR based on the visitors selection from the DBR1
dropdown above. (this form would POST results to itself)

In a nutshell - If I use the DBRW to create a DBR display area using Search
Fields I can accomplish the Form with a dropdown (DBR1) which the visitors
makes a selection from to be the parameter for the display in the 2nd DBR.
What I also need to have happen is that the SEARCH fields (plus additional
text fields I add) ALSO need to submit to a DB Table all on the same CLICK OF
SUBMIT.

Is this possible? Any articles I can reference?

 

[Stefan B Rusynko]

Try http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| RE: FP2003 with Access 2002 DB
|
| I want to create a form using DBR to provide a dropdown list for Visitor to
| select from (DBR1), plus add additional fields - this form submits to the DB
| - all works here (this form would submit results to a DB table)
|
| Tricky part for me is that I also want this same form to be the criteria for
| displaying a second DBR based on the visitors selection from the DBR1
| dropdown above. (this form would POST results to itself)
|
| In a nutshell - If I use the DBRW to create a DBR display area using Search
| Fields I can accomplish the Form with a dropdown (DBR1) which the visitors
| makes a selection from to be the parameter for the display in the 2nd DBR.
| What I also need to have happen is that the SEARCH fields (plus additional
| text fields I add) ALSO need to submit to a DB Table all on the same CLICK OF
| SUBMIT.
|
| Is this possible? Any articles I can reference?
|