If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
2 forms
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 |
#3
|
|||
|
|||
2 forms
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 |
#4
|
|||
|
|||
2 forms
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 |
Thread Tools | |
Display Modes | |
|
|