Connection between forms - Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have connected my main form to another form via a ref no, the second form
includes a subform, when testing the second form the link appears to be to
the first record on the first form, I can't get it to generate a new form for
each record, any ideas? Please forgive the non technical terms, fairly new
to access.
 
I have connected my main form to another form via a ref no, the second form
includes a subform, when testing the second form the link appears to be to
the first record on the first form, I can't get it to generate a new form for
each record, any ideas? Please forgive the non technical terms, fairly new
to access.
Click to expand...

The first thing to realise is - Forms are *just windows*. They don't
contain any data; the data is stored in Tables, not in Forms. As such
you can't really "link to" a Form in the sense it appears you're
using.

I am not sure why you're getting the effect you see. Could you explain
how you "connect" the form? What are the Recordsource properties of
the two forms and the subform? What are the Master Link Field and
Child Link Field properties of the subform?

John W. Vinson[MVP]
 
The record source I have used is 2 tables, the primary key for both of these
is a number, I haven't changed any of the other field properties. I have
inserted a command button to the Master table which takes me to the second
form, which is the subform. Help much appreciated.
 
The record source I have used is 2 tables, the primary key for both of these
is a number, I haven't changed any of the other field properties. I have
inserted a command button to the Master table which takes me to the second
form, which is the subform. Help much appreciated.
Click to expand...

Now this is confusing.

A Subform isn't a "second form", and doesn't need any buttons or code
to open it. It's an object within a Subform Control on your main form.

I take it you want a "popup form" instead, a form which just happens
to have a subform on it?

If that's correct, please post the code which opens the second form,
and what you're seeing vs. what you expect to see.

John W. Vinson[MVP]
 
Back
Top