Senin, 12 Agustus 2013

RE: [MS_AccessPros] coding problem

 

Glenn-

What is Questionaire - a Form object?

If it works in the Detail section, it should work in the form header. Can
you post the entire bit of code?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Glenn Lloyd
Sent: Monday, August 12, 2013 2:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] coding problem

This code:

360 Set .Questionaire = Me.fsbSurvey_Details.Form

When executed from a combo after update handler in the form's details
section executes correctly.

However, if the combo is located in the form header, it generates a run-time
error, "You entered an expression that has an invalid reference to the
property Form/Report. fsbSurvey_Details is a subform control in the form's
detail section. I have tried to reference the Form through the controls
collection me.controls("fsbSurvey_Details").Form but that generates the
same error.

Can anybody suggest where I am going wrong and how I can reference the
subform's foru?

Glenn Lloyd

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar