Access Pages

[jwindon]

How do I make a list of controls display the field data that corresponds to the data of a drop down box?

I use the dlookup on a form to do this. How can I do this on a Page. Ideally, I would like to have the Group (drop down box) expand after selection and reflect the relating record(s).

Please answer me simply. I don't write Code.
Thanks.

 

[shacket]

Use the Access wizard for a combo box. Choose the 3rd option "Find a record on my form based on the value I selected in my combo box."

 

[jwindon]

I tried this in the Access Page design view and THAT option is not shown in the wizard. It IS shown in the Access Form combo box wizard. Do you know if it can be done in a page? HELP! I want this so bad!!!!!!!!

 

[shacket]

If you choose the combo box icon and click to place a combo box on your form, the wizard should automatically start.

 

[jwindon]

Let me say it again...THAT option is NOT available using the wizard on ACCESS PAGES?!?

 

[shacket]

I am not sure what you mean by "Access Pages" and that the wizard is not available.

When you are on a form, how do you place a combo box on it?

If it is from the toolbox, and you choose Combo Box, do you mean that you click on the form and you just get a combo box, with no wizard popping up to help you?

The way this should happen is that on the toolbox, you click on the combo box icon, and when you click on the form to place it there, a wizard pops up to help you.

Explain to me what part of this is different with what you are looking at.

 

[sheederj]

you need to make sure that the wizard button is selected as well, it looks like a magic wand, if it is not selected when you click on the button to make the combo box, or anything else, the wizard will not start.

 

[jwindon]

Ok. Let me try explaining it this way. It may be overkill, but I'm trying to be clear.

I use Access 2000. I use the icon "PAGES" on the sidebar in the database window. Right under "Reports" and above "Macros".

I go on and make my page from the Create Data Access Page using wizard choice.

On that page in design view, I select drop down list from the tools toolbar, put it on my access page. Yes, the wizard starts, but the option to find data based on my combo box DOES NOT show.

It may not be possible, but THIS is what I was asking. How do I do the same thing on the Data Access Page as works in Forms.

 

[pcs]

i don't use data access pages, but all the stuff on the MS site seems to indicate that combo boxes are supported...

found this cryptic entry:
------------------------------
Wizards are not available in a stand-alone data access page, or when you point a data access page to a database other than the one currently open. In both cases, you will have to create the list box or drop-down list box on your own.
------------------------------

curious - what does the first page of the drop down wizard show...?

hth,
al

 

[shacket]

OK, sorry I didn't figure that out. "Pages" is short for "Data Access Pages" which are used for posting Access information to a web page. If you are not using this for web publishing, I would HIGHLY recommend that you move over and use forms.

I did look up under Data Access Pages in the Help section and found this quote:

"Record navigation Used to display the record navigation control for the group level. A record navigation section for a group appears after the group header section. You can't place bound controls in a record navigation section."

If you can't place a bound control in the Record Navigation section, you cannot use a combo box to navigate records in a Data Access Page.

I am not familiar with Data Access Pages but that is my best guess reading through the help files quickly.

I hope you find your answer!

 

[jwindon]

That's what I thought. It just isn't an option. You know how you see that on web pages. The drop down box with options that set what the fields below see? Have you ever seen that? THAT is what I'm trying to create.

 

[MarcoM]

Hi there,
you mightwant to try http://wa.apana.org.au/~abrowne/ser-05.html

At the bottom of the page there is the info you need. It basically says that you can access the fields of the ComboBox by using
[ComboBox].[Column](i) where i is the column number on the ComboBox (counting from 0).

Then put something like
= [cbxTheBox].[Column](0)
in the Control Source Property of the List Box

Hope this helps,
marco

[This message has been edited by MarcoM (edited 08-17-2001).]