Solved: Access 2007, Transferring Data

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ginaw

Thread Starter
Joined
Sep 8, 2010
Messages
81
I created a database with a subform and would now like to transfer a table into the dbase from a previous dbase. There is a One to Many relationship established between two tables and the data is to go into the child table. Referential integrity between the two tables has been established.

My subform will not refresh now that I have added the new table. It updated fine when the child table was empty. All relationships are still in tact.

Is there a way to get my subform to update?
 

karlhaywood

Account Closed
Joined
Jan 17, 2010
Messages
680
Check the master/child links

also some vba to refresh the subform:

me.subformname.Requery
 

OBP

Joined
Mar 8, 2005
Messages
19,895
If you have referential Integrity set in your relationship it may be stopping the subfrom working.
Can you post a screen shot of your relationships and an example of some data.
 

ginaw

Thread Starter
Joined
Sep 8, 2010
Messages
81
Thanks to you both for responding. I sorted out the problem. I needed to create a Macro to refresh the subform and this took care of it.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top