Cascading boxes

[v!ctor]

Hello

I want to create a database with cascading boxes. I have a sample that has a form that filters the data from 4 tables and I want this data to be saved in a table. Can please anyone help me how can I do this?

Attached please find the database. The table which I want to save the data is tblTotal.

thank you

[June7]

Why would you need to save these selections to a single table? Just build a query that joins the tables and all the related info is available. You attempted that with qryTaxonomy but need to change the join types from INNER to RIGHT so all species will show.

SELECT tblPhylum.KingdomID, tblGenus.PhylumID, tblSpecies.GenusID, tblSpecies.SpeciesID, tblSpecies.SpeciesName, tblSpecies.Description
FROM tblKingdom RIGHT JOIN ((tblPhylum RIGHT JOIN tblGenus ON tblPhylum.PhylumID = tblGenus.[PhylumID]) RIGHT JOIN tblSpecies ON tblGenus.GenusID = tblSpecies.GenusID) ON tblKingdom.KingdomID = tblPhylum.KingdomID;

Now you can build a search form that uses that query as source data.

However, as you will see in that query, many species do not show associated kingdom and phylum. Are your datasets for Genus and Phylum tables incomplete?

Species record 122 has genus (Dermacentor) but no species info.

Species record 120 has misspelled description of Arorwleaf Clover.

[v!ctor]

First of all, thank you for the reply.

My form starts entering the "man" and "date" field. After choosing the route of the work via the cascading boxes I manual enter the "quantity". I need all these data in a new table in order I can manage them as I want (e.g by "man" and "date"

Attached please find the real database (its not finished yet).

The ideal for me would be to create a button at the end to enter these data.

very much appreciate for your help and for any suggestions

[June7]

If you want to save data to table then bind form to table, bind comboboxes to fields.

Here is demo of cascading comboboxes http://datapigtechnologies.com/flash...combobox2.html

You have lookups set in tables - I advise against that, review http://access.mvps.org/access/lookupfields.htm

Be aware cascading combobox with lookup alias will not work nice in continuous or datasheet view form.

[v!ctor]

I am very new in access and I am confused....
I dont know how to bind the form (that already reads from other tables) to the new table.

thank you for your help

[June7]

I am confused by your confusion. Building bound forms with bound controls is basic Access functionality. Access Help has guidelines. Set the form RecordSource property, set controls ControlSource property.