Cascading Combos in Data Access Page [DAP]

  • Thread starter Thread starter Agnelo Fernandes
  • Start date Start date
A

Agnelo Fernandes

In DAP, can I have 1 control [courses] affect other 2 controls
[course_date_1st_choice] and [course_date_2nd_choice].

I usually do this in Form by using Select Case but i need to know how i can
manage to do it in DAP.

Any help please?
 
My recommendation is similar to Sylvain's. Don't try to use DAP for this;
refreshing a page and changing the data is not easy to do.

If you really need to do this, then I'd suggest using cascading pages...
first page lets you set the first combobox, then navigate to second page
where you use the second combobox, where's its data have been filtered by
the value of the combobox on the first page. This can be done using cookies.

I have a sample database that shows how to use one page to filter the
recordset of a second page. It could serve as an example of how you might do
what you seek, but I admit upfront that I've never tried to do what you want
to do.

Data Access Page: Use DAP to filter a subsequent DAP
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterDAP
 
Back
Top