Query with 2 Tables Linked Problem

[sondriven]

I have a query that is linking 2 tables together by a ID Number.

One table is for the part number.

The second table is for the part number description.

I use this query in a subform and it works great. I click the part number combo field and the description automatically follows in the second field.

Heres my problem though...

When I need to edit a table, say a description, it messes up the records. For example: Say I needed to edit the size description of a part. So I go into that table edit the data and save it then close it. I then go into a record that could have contained the data I edited, the new description is there, but the part number is missing. I can click the part number to get it back but Im confused on why this is happening.

Because once I edit a description, I dont want to worry about records getting messed up afterwards.

Thanks for any input you may have.

John

 

[Emohawk]

Is the form/subform open when you edit the table? It may just need some code to Requery your the queries on you forms. Otherwise check your relationships between the two tables.

Just a thought.

Not a very good one but a thought nonetheless...