How to make form with 2 queries

DaniBoy

Registered User.
Local time
Today, 22:02
Joined
Nov 18, 2001
Messages
174
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
 
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?
 
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.
 

Users who are viewing this thread

Back
Top Bottom