Record in one record matches record in another table

  • Thread starter Thread starter nhc los angeles
  • Start date Start date
N

nhc los angeles

I have a Proposals table with a Project # field and a Projects table with a
Proposal # field. I want the Project # and Proposal # fields to cross
reference by adding a go to field or button. If the field is blank in a
particular record, I dont want it to go anywhere. How do I write the code?
 
I have a Proposals table with a Project # field and a Projects table with a
Proposal # field. I want the Project # and Proposal # fields to cross
reference by adding a go to field or button. If the field is blank in a
particular record, I dont want it to go anywhere. How do I write the code?
Click to expand...


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
 
Back
Top