Can't keep Table 2 in sync!!!

[rickm4]

Hi all, I have created a database that includes 2 tables (Projects , Updates) The two tables are joined via the Projects ID field. If i set up a sub form using the updates table, The projects ID #'s from both table will stay in sync as i scroll through the records. I decided i would rather have a TAB form to use for the Updates table. The problem is, if i am on record 30(or any other # but 0) and i tab to the updates form, the Project ID number is still 0(??) I need the number to stay in sync!! Is there anyone that can point me in the right direction? Please keep in mind, i am new to Access and V/B so please use "Newbie" terms. Thanks in advance!!!

 

[RickSpr]

What do you mean by a "TAB form"? Do you mean you removed the subform and created a separate form for the Updates table? Do you mean you replaced the subform with a Tab control? Something else? Rick Sprague

 

[rickm4]

Sorry Rick, I was trying different formats, I found i had more room on the main form if i created a second page via a Tab(from the tools menu) Soory for the confusion, if it would help i could e-mail you the D/B, it is small. Thanks

 

[RickSpr]

Well, it sounds like you no longer have a subform, but have put the Updates table on the main form with the Projects table. In that case, your form's Record Source must be set to a query that includes both tables, right? If so, you have two ProjectID fields, one from the Projects table and one from the Updates table. Are you saying these don't stay in sync? If so, make sure your query shows a join line between the two tables at the top of the query grid.

If I've got the wrong idea, try to describe what you have, including form Record Sources and the Control Sources for the controls that are giving you a problem. If you're using any multitable queries, describe those too, and their relationships to the forms.

I could let you email me the database, but in the long run you'll be a lot better off if you learn to describe what you have. It will tune your thinking to the terms used by Access, which will make the help files much easier to comprehend. Besides, I really don't want Tek-Tips to become a debugging service. I already have a job. Rick Sprague