SubForms

  • Thread starter Thread starter Aurora
  • Start date Start date
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
 
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??
Click to expand...

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?
 
Back
Top