Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform in Access 97

Status
Not open for further replies.

drm184

MIS
May 25, 2001
35
US
I have a subform created and embedded into another form. The subform contains three fields, a line number (PK), a pressure and temperature field. The Pressure and temperature are filled in based on the line number that is displayed. It works correctly when I have the subform itself open. Yet, when I insert it into another form, a valve form, the records will change correctly and everything will update correctly as I go through the valve records, but when I try and change the line that the valve is in. The pressure and temp won't update. The line number is in the valve table, but there is also a line list table which holds all the line numbers, pressures, and temperatures, and that table is what the subform is based off of. Any ideas? Thanks for the help.
 
Also the subform should say 1 of 197 records when open in the other form, but it doesn't. It says one of one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top