View Full Version : How to make form with 2 queries


DaniBoy
12-06-2001, 12:08 PM
Hello, I am trying to make a form from two queries, but I dont want it to have a subform. Every time I try to do it, I cant make it so is just one form with out a subform. If there is anyone out there that I could call to explain what I need to do, please send me your phone number and I'll call you. There is a lot to explain.
Thanks

John.Woody
12-06-2001, 12:13 PM
Just a thought. Have you tried creating a new query based on the 2 existing queries you have and then using the new query as the source for your form?

DaniBoy
12-06-2001, 12:49 PM
Thanks, yes I tried a couple of ways but always comes up with the subform. Ok, this is what I have, two tables, tblCustomers and tblAddress. I want to be able to enter the customer information "Fname,Lname,Hphone,Wphone" and the address information "Address, City, State, Zip" all in one single form. I had to do different tables for Customers and Addresses because the County has special number to identify an addresss, and Customers usaly move around and change but addresses are always going to be the same. In other words I cant say an address is always going to be for one customer and a customer is always going to be for that address.