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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

records not matching between forms

Status
Not open for further replies.

newbieone

Technical User
Jan 3, 2006
50
US
Have two forms with separate tables behind each. have code that will take unique id from Form1/Table1 check to see if there is a like number on form2/table2 and if not add a new record. the problem is that when the code runs I have one more record showing on form2/table 2 nav buttons then what is on form1/table1 even though the id's match.
How do I get everything to match
 
newbieone,
Filter form2 after the new record is created:
Code:
With Forms("form2")
  .Filter = "id=" & [i][id_value_from_form1][/i]
  .FilterOn = True
End With

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top