Dependent combo box in Web Database

[Office10]

Hello,



See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent

In the main form needs to select one customer, only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) ..
I do not succeed despite several attempts with macros to achieve this.

Anyone have an idea how to solve this. Preferably modify the file so that I see the solution.

Thanks in advance.Example11.zip

[June7]

Contact combobox RowSource: SELECT cntName, CompanyName FROM Contacts WHERE CompanyName=[Keuzelijst0];

Then must requery the contact combobox after customer selected. Use AfterUpdate macro of customer combobox.

This is so simple with non-web db. However, this is insisting the reference to customer combobox in the RowSource be a parameter declared with Query Parameters dialog. I've never done this. Do you know where to go from here?

[Office10]

I did what you said, but I get a message that something is not going well with [Keuzelijst0] and query parameters, see Attachement. Do you know what this is? Maybe I forgot some statement?
Example11.zip

[June7]

I've never built web database nor used Query Parameters dialog.

As far as I can tell, the actual value of CompanyName field in Contacts is the ID from Customers because of Lookup, not the company name. This means the Customer combobox properties should be:

RowSource: SELECT ID, custName FROM Customers;
ColumnCount: 2
ColumnWidths: 0";1.5"

I found the Query Parameters dialog. It is available when a query is open in design view. I opened the contact combobox in design view and don't see any query parameters. I tried setting one but it doesn't offer Integer data type. Review this thread on the same issue https://www.accessforums.net/access/...xes-40936.html

[Office10]

Have been attached an easier example. I build this example according to the site:

http://social.msdn.microsoft.com/For...orum=accessdev

It is intended that when selecting Edmonton City in cboCity the, City Edmonton in cboStores can be chosen, and not city Vancouver.

Unfortunately this does not work. Possibly you can specify how this file works (see attachement).. So that I can apply it to my previous file.Easier Example11.zip

Please change the file and upload as Zip/RAR so that I not misunderstand what you mean.

[June7]

Your TempVars variable is referencing wrong combobox. Should be cboCity.

There is no Lookup setting for the City field in tblStores so it is saving the actual name, not ID. Change cboCity properties to:
RowSource: SELECT City FROM tblCity;
ColumnCount: 1
ColumnWidths: 1

Change the RowSource for cboStores to:
SELECT tblStores.ID, tblStores.Store, tblStores.Address FROM tblStores WHERE (((tblStores.City)=[TempVars]![strCity]));

If you want to see the store address in the combobox list, change:
ColumnCount: 3
ColumnWidths: 0";0.5",1.0"

[Office10]

Easier Example11.zip


I made the changes, see attachement but it still does not work...

[June7]

Didn't make all the suggested edits. The embedded macro for cboCity still references the wrong combobox for setting the TempVars variable. Change it to cboCity.

Then you went and set lookup for City field in tblStores so now cboCity RowSource must include the ID field and fix ColumnCount and ColumnWidth properties.

Works perfectly.

[Office10]

Thanks, largely works now, I only see now a number below City column instead of the cityname at cboStores (combobox field in the form). How can I make sure that the name of the city comes to stand under column City in cbo Stores? See also attachement

Easier Example111.zip

[June7]

cboStores properties:

RowSource: SELECT tblStores.ID, tblStores.Store, tblStores.Address FROM tblStores WHERE (((tblStores.City)=[TempVars]![strCity]));

ColumnCount: 3

ColumnWidths: 0";0.3938";0.3938"