Record in one record matches record in another table

Record in one record matches record in another table

Post by Marshall B » Thu, 22 Oct 2009 23:35:26


nhc los angeles <nhc los XXXX@XXXXX.COM >




The command button wizard will create the code needed to
open another form.

To filter the other form's to the matching field, modify the
code to something like:

Dim stDoc As String
Dim stWhere As String
stDoc = "name of other form"
stWhere = "[Project or Proposal # field] = " & Me.[Project
or Proposal # field]
DoCms.OpenForm stDoc, WhereCondition:= stWhere

--
Marsh
MVP [MS Access]