2 forms

Hello everybody

I am using Access 2003

DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables

Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.

How can I do this.
I tried synchronisation but it does not work, the result comes with a blank
CustomerID field in table2

Thanks in advance
Activo

When you add a new record to the form's recordset, it does not get entered
into the table until you close the form or do a Requery.

What you really should do is use a subform control on the main form that has
table2 as its recordsource. Use the Link Master Field and Link Child Field
properties of the subform control to relate table1 to table2.
--
Dave Hargis, Microsoft Access MVP


"Activo" wrote:

Hello everybody

I am using Access 2003

DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables

Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.

How can I do this.
I tried synchronisation but it does not work, the result comes with a blank
CustomerID field in table2

Thanks in advance
Activo

Thanks for the rapid responce
Will do as suggested and report the result


"Klatuu" wrote in message
...
When you add a new record to the form's recordset, it does not get entered
into the table until you close the form or do a Requery.

What you really should do is use a subform control on the main form that
has
table2 as its recordsource. Use the Link Master Field and Link Child
Field
properties of the subform control to relate table1 to table2.
--
Dave Hargis, Microsoft Access MVP


"Activo" wrote:

Hello everybody

I am using Access 2003

DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables

Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control
on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.

How can I do this.
I tried synchronisation but it does not work, the result comes with a
blank
CustomerID field in table2

Thanks in advance
Activo

Dear Dave

I tested this but unfortunately it did not work for me

1- The subform allows only one record to be entered and I can not browse
other records of the same customer, I need to be able to see other orders
placed by the customer on display
2- I really need a pop up form to be used only upon request, not all
customers will place orders

Thanks again,
Activo


"Klatuu" wrote in message
...
When you add a new record to the form's recordset, it does not get entered
into the table until you close the form or do a Requery.

What you really should do is use a subform control on the main form that
has
table2 as its recordsource. Use the Link Master Field and Link Child
Field
properties of the subform control to relate table1 to table2.
--
Dave Hargis, Microsoft Access MVP


"Activo" wrote:

Hello everybody

I am using Access 2003

DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables

Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control
on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.

How can I do this.
I tried synchronisation but it does not work, the result comes with a
blank
CustomerID field in table2

Thanks in advance
Activo