B
BZeyger
Hello,
I have an Access Database that consists of many forms. If a users selects a
record, it needs to look at the tech ID and Source Data ID of a record to
open a new form.
I currently have:
stLinkCriteria = "[Tech Manual ID]=" & Forms![TMINS vs Source Data (mainform
- filter by project)]![Tech Manual ID]
The entire code is
stDocName = "Bib Data Mainform"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.RunCommand acCmdRefresh
stLinkCriteria = "[Tech Manual ID]=" & Forms![TMINS vs Source Data
(mainform - filter by project)]![Tech Manual ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
I am having trouble with the statement.
I would like it to open the form with the Tech Manual ID and Source Data ID
stored from the record selected.
What should I have as the stLinkCriteria?
Thanks for your time
I have an Access Database that consists of many forms. If a users selects a
record, it needs to look at the tech ID and Source Data ID of a record to
open a new form.
I currently have:
stLinkCriteria = "[Tech Manual ID]=" & Forms![TMINS vs Source Data (mainform
- filter by project)]![Tech Manual ID]
The entire code is
stDocName = "Bib Data Mainform"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.RunCommand acCmdRefresh
stLinkCriteria = "[Tech Manual ID]=" & Forms![TMINS vs Source Data
(mainform - filter by project)]![Tech Manual ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
I am having trouble with the statement.
I would like it to open the form with the Tech Manual ID and Source Data ID
stored from the record selected.
What should I have as the stLinkCriteria?
Thanks for your time