combo boxes on pages

[elsa]

I work in Access 2002.
I have designed a page based on a table to CAPTURE
information.
I do not know how to get the combo box on the page to
display specific data. The page was designed using the
page feature in Access.
I know how to do this on a Form using the LOADED FORM
procedure!
Example
I have a Jobno 888
When I click on the combo box to select a unit, I only
want it to display the units for job 888.

I would appreciate some help! Thanks!

 

[Tom Wickerath]

Try this KB article to see if it helps:

How to Synchronize Two Drop-down Lists on a Data Access Page
http://support.microsoft.com/?id=232592

Tom


____________________________________


I work in Access 2002. I have designed a page based on a table to CAPTURE information. I
do not know how to get the combo box on the page to display specific data. The page was
designed using the page feature in Access. I know how to do this on a Form using the
LOADED FORM procedure!

Example
I have a Jobno 888
When I click on the combo box to select a unit, I only want it to display the units for
job 888.

I would appreciate some help! Thanks!

 

[Guest]

Hi Tom

Thanks, I tried the article on my information. It is not
quite the same scenario, but it got me on a track. I am
sure if I keep at it I will figure out something.

I have to use the currently selected item and not choose
something from a list.

If somebody else out there can still assist me I will be
grateful.

Thanks again
Elsa

-----Original Message-----
Try this KB article to see if it helps:

How to Synchronize Two Drop-down Lists on a Data Access Page
http://support.microsoft.com/?id=232592

Tom


____________________________________


I work in Access 2002. I have designed a page based on a

table to CAPTURE information. I

do not know how to get the combo box on the page to

display specific data. The page was

designed using the page feature in Access. I know how to do this on a Form using the
LOADED FORM procedure!

Example
I have a Jobno 888
When I click on the combo box to select a unit, I only

want it to display the units for