Data access pages and combo boxes

[elsa]

I work in Access 2002.

My database is up and running and working great. I made
quite a few data access pages for capturing data and to
view Pivot table reports.

My problem is that on one of the pages that I use to
capture data, I want to make a change to a combo box.
Let's say the grouping shows Jobnumber 888, then I wnat
the UNITS to be selected for this jobnumber to be the
UNITS assosiated with Job 888 only. There is a grouping
on the Jobnumber.

Please help. I have been trying to find a solution for 2
weeks now!!!

Much appreciated
Elsa

[Wm3]

Elsa I'm amazed that you've done so much work with combos
and Data Access Pages (DAP). This appears to be new
ground. I've used Access a lot but only recently started
using DAP. I'm very good at making WebPages and just
started a lot work on Dynamic Pages (Dreamweaver Ultra4,
Sybase, Access, etc.) Each of them have their strengths
and weakness.
I too am having problems with DAP combo boxes... In
forms when you're having problems with combo boxes, all
you do is start over, i.e. delete the old combo box and
create another one. This ensure correct coding, etc. My
problem with combo boxes and DAP is that I can't get the
functionality I have with forms i.e. can't get the option
to for fill data/page with value selected in combo box to
work in a DAP. I'm sure there's some extra coding
required in a design view field... but what field?

P.S. Dreamweaver does excellent work with Flash/rollover
command boxes and other flash stuff, have you gotten
Access to do this kind of stuff?

>.
>

[Wm3]

Here's an interesting fix to add to your combo box
trials...

SUMMARY
This article shows you how to create and use a Group
Filter control on a data access page. The example in this
article uses the sample database Northwind.mdb.
MORE INFORMATION
A Group Filter control is a drop-down list box with a
Select Distinct clause, sorted in Ascending order for a
specified field in the section's recordset. The Group
Filter control controls the current recordset for that
level of the hierarchy. By default, the Group Filter
control has no value. This means that when you create a
section with a Group Filter control on it, there are no
records available until you select a value from the drop-
down list. At this point, that level of the hierarchy is
populated, and any children it may have are also
populated.

This type of control can be compared to a combo box on a
form that finds a record on that form based on the value
selected in the combo box. The control itself is not
bound to the underlying recordset; it merely provides you
an interface for selecting records.

Each group or level of a data access page can contain a
single Group Filter control. When you place a second
Group Filter control in a section, the original control
is "demoted" to a drop-down list. The properties that
determine which drop-down list in a section, if any, are
to be implemented as a Group Filter control are Group
Filter Control and Group Filter Field. Although you can
use a wizard to help you create a Group Filter control,
you can also set these properties manually. You can
access both properties through the Sorting and Grouping
dialog box.

To create a Group Filter control:
Open the sample database Northwind.mdb.
Create a new data access page based on the Customers
table.
If the field list is not displayed, click Field List on
the View menu.
Add all the fields from the Customers table from the
field list to the data access page.
Right-click the CompanyName control on the data access
page, and then click Promote on the shortcut menu.
If the toolbox is not displayed, click Toolbox on the
View menu.
Click the Dropdown List control in the toolbox.
With the Dropdown List control still selected in the
toolbox, right-click the Country field in the field list,
hold down the right mouse button, and then drag the
Country field from the field list to the Customers
section of the data access page.
When you drop the field on the data access page, a
shortcut menu appears. On this shortcut menu, click Group
Filter Control.
On the View menu, click Page View. Note that all of the
controls appear on the data access page, but that neither
the input box, nor the drop-down list displays any data.
In the drop-down list, select one of the countries. Note
that the input box is populated with the first customer
from this country and that the record navigation control
displays Customers 1 of n, where n is the number of
customers in this country.

With each change of the value in the Group Filter
control, the currency of the section changes, as does the
number of records in the navigation control.

>.
>

[elsa]

Thanks!! This did not actually solve my problem, but I
realized I could just put the UNIT in a group as well and
that was it!!

Thanks for putting me on the right track!!

>.
>