M
Mergowyn
I am very new to Access VB programming, so all help is greatly appreciated.
I have a form that is used to both enter and view information from one table. A subform is used to relate the data entered in the table to the data in a query. When the last field in the form is On Enter, a VB command is used that links the data in the form to the subform
[Form_ForecastData].[CallClosed] = [Form_User1Q2 subform].[CountOfOrder
The subform uses a query as a record source. That query uses another query as its record source, so that it can relate data from 2 other tables. The goal is to populate the last field of the table with the data pulled from the second query.
The problem is that the VB syntax is not working. A friend who is an Access/VB whiz explained to me how to use the subform to achieve linking the data in the form to the data in the queries. However, he is out of town and unreachable
The problem is that the syntax is only supposed to work if the subform appears as an object in VB, under project, under Microsoft Access Class Objects. But the subform does not appear as an Object.
Do you have any suggestions for linking the subform with other syntax? Or perhaps another way to link the data through to the queries to populate the CountOfOrder field?
Thanks,
Marc
I have a form that is used to both enter and view information from one table. A subform is used to relate the data entered in the table to the data in a query. When the last field in the form is On Enter, a VB command is used that links the data in the form to the subform
[Form_ForecastData].[CallClosed] = [Form_User1Q2 subform].[CountOfOrder
The subform uses a query as a record source. That query uses another query as its record source, so that it can relate data from 2 other tables. The goal is to populate the last field of the table with the data pulled from the second query.
The problem is that the VB syntax is not working. A friend who is an Access/VB whiz explained to me how to use the subform to achieve linking the data in the form to the data in the queries. However, he is out of town and unreachable
The problem is that the syntax is only supposed to work if the subform appears as an object in VB, under project, under Microsoft Access Class Objects. But the subform does not appear as an Object.
Do you have any suggestions for linking the subform with other syntax? Or perhaps another way to link the data through to the queries to populate the CountOfOrder field?
Thanks,
Marc