SubForms

A

Aurora

I am using Access 2000
I have a Db with 2 tables (1 to many relationship). I
created a form with Cust Information from the AcctTable.
I then created a 2nd form from the 2nd table with
information regarding telephone messages received. This
form has a lot of drop down menus and Option groups in the
form.
I added the 2nd form to the first form as a subform. )They
are linked by telephone number.) But it will not give me
a blank form. I have created subforms before but they are
usually in a Datasheet view where there is "one line" of
information to be completed and a 2nd blank line is
available when you call up the same customer again and
need to add more information.

Is it because I added the subform as a real form that I
can not get a blank form the next time I pull up the
customer? Is there anything I can do to correct this??

Aurora
 
J

John Vinson

Is it because I added the subform as a real form that I
can not get a blank form the next time I pull up the
customer? Is there anything I can do to correct this??

No; I use "real forms" as subforms all the time. What are the
Recordsource properties of the Form and the Subform? What are the
Master and Child Link Fields? If the Recordsource of the subform is a
query, can you open that query (as a query datasheet) and edit it or
add new records?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top