I've got to built a form based on many Tables. Knowing that I cannot do it directly from tables, I created a Query that takes all the fields in Customers, Orders, Employees and saved it like that. Then I moved to the form tab and ask the Assistant to build the form automatically... but it does'nt work as I've planed and it created errors. All the fields in Orders (except one) display's "#name?". The other fields are ok... but I don't need 'em on the form itself... I only need 'em to have their values to fill the blanks... does any one here ever had to work on a form like that and could show me a way to do it?

You CAN build a form and have its data came from more than one table! just goto the wizard and select the table and the fields you want.

It probable says NAME because in the properties it may have = before the source ie

=client name,

Get rid of the = and it may work, if not start again and re-do your form, and gets its info from more than one table.

No... i've built the query and I used the assistant to create the form... so that's not the problem. When I try to change something like a textbox into a list it gives error like incorrect syntax in field x... but how could the syntax be incorrect if I made it built by access?

Sorry, I don't have an answer. I also have been struggling with the same thing for weeks now and I can't get it to work either. I am adapting the Northwind database to do the same as you. I want a form based on the following tables: Customers, Orders, Categories, Products. I want the categories in a combo box from which I will select a category and beside that a product box which will display all products related to the category that I choose. I can manage to do this on a form of its own but when I incorporate it with Customers and orders it doesn't work and I get the same error message you do. I have posted here and on three other help forums and no-one has been able to come up with a solution. In frustration I have sent away for a $100 Access programming book to see if I can work it out for myself. It will probably take me a month of Sundays but when I have it worked out I will let you know. I hope you are not in a hurry! Sorry I can't be of more help. Yet.

Billy if you send me a zipped copy of your db in acc97 I'll take a look.
richiet@lineone.net

I've got half of it done. The fields does'nt give me errors now just that it gives me problems when iI do the list... the fields in it are ok but when i select one it say's "fields x does'nt exists"... I just have to solve that damn fields problem and everything should work.

Spazm

Thanks Rich,
I have deleted the one I was working on because I had got myself into a heck of a tangle, and started working on a new one last night I will work on it again tonight and email it to you.
Thanks very much for the offer, if you can help me out I will send you something from Godzone. (NZ)
I have become hooked on databases since I started playing around with them, but I'm afraid my aspirations outstrip my knowledge base. I have ordered the Access 2002 bible to help me get up to speed but it has to come from Australia as none of the shops here have a copy and I probably won,t see it for a fortnight.
Anyway thanks again, I'll email it to you asap.
Billy

Not that I am the know-it-all, but I have set up forms with the most success WITHOUT using the wizards! You can easily start new combo boxes onto a form and then define where they should pull the data: right click on the "Unbound" box you just created, choose properties, choose "DATA" from the tabs above. Name the combo box something sensible instead of Combo138 etc. Click to the right of the "Control Source" on t he "..." and then weave your way thru the list of tables, open the table you want, then selct the Value you want from the FARTHEST window to the right. After a couple of times, this becomes a very quick and easy process.