Selecting subform data with a combobox

[neash83]

Hello,

I am creating a relatively simple web access database. For examples sake I have two tables Customer and Orders.

There can obviously be only one unique customer and in the order table multiple orders assigned to one customer. I’ve created a Customers Form page which shows the general customer information and I would then like a subform within this form which displays the various order information for a customer. I can get this to function in this manner using a datasheet form dropped into the subform, then the various text fields for the order information change depending on which order you have selected on the datasheet. However the way I would like to do it is with a combo box, so instead of users selecting the order from the datasheet I would like them to select from a combo box which will show all the orders linked to that customer. Depending on which order they have selected the form fields will then update to show the corresponding information.

Is this possible to do in a web database in Access? If so which direction should I be looking as I have tried dropping a combo box and changing the control source, but with little luck.

Thanks

[June7]

Never built a web db so can't say for certainty. What does 'with little luck' mean, what happens - error message, wrong results, nothing?

Have you explored some existing web db templates for design ideas?