sub forms & combo boxs

[clean32]

HI



i have a form with 2 combo boxs on it, and nothing else

i need a sub form to filter its records off the values in the 2 combo boxs.

i even tried the wizzard i keep on getting not embeded.

doint want to use a filter becouse the subform is where the data will be enterd

cheers

[June7]

I don't understand your comment 'i even tried the wizzard i keep on getting not embeded'.

Check out these tutorials:
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...earchform.html

[clean32]

I don't understand your comment 'i even tried the wizzard i keep on getting not embeded'.

Check out these tutorials:
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...earchform.html

thanks for that, but i dont want a filter, i would prefer to link the sub form as the subform will also need to have data put into it. if i use a filter, that will dispay but will not update the ID fields if i put in a new record

so main form
combo box 1 from a table and combo box 2 from another table.

the sub form is based on a 3rd tale that also has the same fields as the first 2 tables.

in access one, i would just have entered the table and fields into the link child link master. but that appears not to be possible in access 2003.

i would welcome any other suggestions. if i have to use a filter then i would have to build another form for DE

[Bob Fitz]

Hi clean32

I think that you can do this.
Let's call the PK's from the first and second tables PK1 and PK2.
In table 3 you have FK's with these names.

Set both the subform control properties called "Link Child Fields" and the "Link To Master Fields" to PK1;PK2

[clean32]

thats what i used to do in 1 1.1
but in 2003 i get this

new form combo boxs. click the subform on tool box, use existing form.

link child fields i click the ... and get this

[Bob Fitz]

Once you have the subform on the main form, just type "PK1;PK2" (without the quotes) in both the subform control properties called "Link Child Fields" and the "Link To Master Fields".

[clean32]

Once you have the subform on the main form, just type "PK1;PK2" (without the quotes) in both the subform control properties called "Link Child Fields" and the "Link To Master Fields".

but thay are combo boxs

so combo0;combo2 master
area;plant type child

i cant use the .... to do it so typing in in manually is ok.

But it seems that it cant see combo boxs. for some reason.

when i open the form it asks for a value for both area and plant type

[Bob Fitz]

so combo0;combo2 master
area;plant type child

This looks wrong to me.

If the names of the combo boxes you are using are "combo0" and "combo2" then the property settings should be:

combo0;combo2 for master
combo0;combo2 for child

please try this and post back with results.

[clean32]

ok done that, no luck

no filter defect and the area and plant on the sub form is not picking up the data from the combos when entering new record

[Bob Fitz]

Strange that this is not working.
I have tried this solution and it is working for me.
Is the bound column of each combo box the first column and is it holding the PK of the of the data it displays?

[clean32]

Strange that this is not working.
I have tried this solution and it is working for me.
Is the bound column of each combo box the first column and is it holding the PK of the of the data it displays?

the two combo boxs have only one column each. though i doint i understand bound. the form is a blank one. each combo box gets its data from its own table.

i doint understand how your method can ID to the two fields in the sub form, "area" and "plant type". if i put "area" and "plant type" in the child field i get the from asking for value when i open it do do any thing with it.

[Bob Fitz]

Can you post the SQL of both combo boxes and the SQL of the subform please.

[clean32]

Can you post the SQL of both combo boxes and the SQL of the subform please.

sure, no problem
one question, how do you do that, i cant see the SQL thing in 2003

[Bob Fitz]

For each of the combo boxes:
Cut and paste the text that is showing in the "Row Source" property

For the subform:
Take a look at the "Record Source" property.
If the text starts with "SELECT....." then .
If it is just showing the name of the table:
Click the three little dots ... on the right.
This will open the Query Builder.
In the Query Builder, double click each of the fields listed in the table so that all the fields are in the query and then close it.
The "Record Source" property will now start with "Select...."
Cut and paste this.

[clean32]

SELECT [Plant type].[Plant type] FROM [Plant type] ORDER BY [Plant type];
SELECT Area.Area FROM Area;

SELECT Item.Item, Item.area, Item.[plant type], Item.[commision date], Item.[supplyer codes], Item.statis, Item.notes, Item.Date FROM Item;