Using set Value

  • Thread starter Thread starter NEC-2008
  • Start date Start date
N

NEC-2008

I have a project that has 3 main forms. Form A B & C.
Form A in the initial contact where ALL the primary information is taken.
Form B is the acceptance of that interview and
Form C is the decline of that interview.

At one point in time or another form A and either Form B or C have to be
printed individually. (Thats why I need them both)

The whole projects works well with one exception.
All the info from Form A, at the tick of a button, has to be transfered to
Form B or C.

I'm using a macro with open form, move size, go to record and my problem,
set value.

On 3 fields, 2 combo boxes & 1 text box, all works perfectly.
On everything else I get a message stating..."You tried to run a VB
procedure to set a property or method for an object. However, the componenet
doesen't make the property or method available for Automation Operation."

Can someone explain this to me please?
Thanks.
 
NEC,

I think I would recommend that you pause a moment, and review the approach
here.

First of all, even though it is theoretically possible to print a form in
Access, this is not their primary purpose. You should really consider the
data entry/edit process, and the data presentation/printing process,
completely separately. One uses forms, the other uses reports.

Secondly, the idea of "transferring" info from one form to another, is
almost certainly mis-conceived. Sorry to be blunt.

In fact, forms don't have "info". Whenever you think about data, you should
be thinking about tables and queries. All the form does is provide a
user-friendly window to access the data, but the data is never in the form.
Hope that conceptualisation helps you.

So, on the basis of what you have told us so far, I obviously don't really
know what you are trying to achieve, in data terms. But I can say for
certain that the approach of using a SetValue macro to write data from one
place to another is not the purpose of SetValue, and there is certainly a
better way to get the job done.

If you want to explore this further, can you please post back with details
of what data you are working with, what tables you have, and how the tables
are related to the forms? Thanks.
 
Back
Top