Form data save?

[pcguy]

Hi,

I have created a form using data created from a Query, I have a few problems I am by no means an Access expert what I need to do is save the data from the form in perhaps a serparate table for when each time the user adds new data it will create a new row if you get what I mean From this I then need to create a report. I also have a combo box that has the in this case childrens name displayed I then want the data from this to be shown in different fields on the form so the user can see the correct data.

I don't want much lol

Hope you understand

Thanks

 

[ezfriend]

Are you trying to filter the form data with the value in the combobox?

 

[reverentcreature]

Hi PCGUY.

If you want the contents of your combo box to change you will need to create a table and link the table to the combo box. You can link the childrens names table to the field(combo box)on you main table by using lookup tab on the table design screen, choosing combo and adding your table to the row source property.