Hi everyone,<br><br>I am working in an Access project connected to a SQL Server database.<br><br>In VB I am not able to access the subform of a form.<br><br>I do<br><br>Forms!SubfrmSearchHistoReg.RecordSource = "SELECT * FROM HistoryRegulation1991-1997 " _<br> & strWhereHistReg1<br><br>It telling me that he cannot find the subform "SubfrmSearchHistoReg"<br><br>Thanks<br>Genevi<br><br>
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subform in an Access project
- Thread starter genevi
- Start date
deed59
Programmer
- May 1, 2001
- 5
You need to reference the main form as well as the subform.
For example if your main form is named frmMain the syntax would be as follows:
Forms!frmMain!SubfrmSearchHistoReg.Form.RecordSource = "SELECT * FROM HistoryRegulation1991-1997 " _
& strWhereHistReg1
deed59
For example if your main form is named frmMain the syntax would be as follows:
Forms!frmMain!SubfrmSearchHistoReg.Form.RecordSource = "SELECT * FROM HistoryRegulation1991-1997 " _
& strWhereHistReg1
deed59
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question