Refer subform field

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

Looked at http://www.mvps.org/access/forms/frm0031.htm but still can't
figure out witch refer to use. Tried various combinations but no effect.

I have a subform on my main form called subTypeEmployee. This sub contains
the field TypeEmployeeID. On the Main form i have a dropdown field
TypeHours. TblTypeHours contains TypeEmployeeID. So in the select query i
want to refer to the subforms Type Employee ID (type limit the list type
hours based on type employee).

How do i do this?

Thanx for any tips!

Regards,
Harmannus
 
Harmannus,

In a query, use the following:
Forms!frmMainForm!subTypeEmployee.Form![Type Employee ID]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Hallo Graham,

Thanx for the reply!

Works great!

Thanx.

Regards,
Harmannus


Graham R Seach said:
Harmannus,

In a query, use the following:
Forms!frmMainForm!subTypeEmployee.Form![Type Employee ID]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Harmannus said:
Hallo,

Looked at http://www.mvps.org/access/forms/frm0031.htm but still can't
figure out witch refer to use. Tried various combinations but no effect.

I have a subform on my main form called subTypeEmployee. This sub contains
the field TypeEmployeeID. On the Main form i have a dropdown field
TypeHours. TblTypeHours contains TypeEmployeeID. So in the select query i
want to refer to the subforms Type Employee ID (type limit the list type
hours based on type employee).

How do i do this?

Thanx for any tips!

Regards,
Harmannus
Click to expand...
Click to expand...
 
Back
Top