Form -> Subform

[Guest]

I have Form A and on Form A is SubForm B. Form A is a single view record
type form. SubForm B is a continuous form. The two forms are not linked
together. When you select an entry on SubForm B it passes the vlaues from
SubForm B to hidden field on Form A and then SubForm B issues a requery of
Form A. The query for Form A is based on those hidden fields.

The probem is that when Form A does a requery, it also requeries SubForm B
which I do not want it to do. Why is SubForm B doing a requery when a
requery of Form A is issued? How do I prevent SubForm B from doing a requery?

Thanks in advance for your help!

 

[PC Datasheet]

Have you considered setting the LinkMaster and LinkChild properties rather
than using your query method to coordinate the forms?

 

[Guest]

yes, there is some processing that I need to do that prevents me from linking
the forms

how do I prevent the requery?

 

[StopThisAdvertising]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)

--
To Steve:
Been away for a little while ??
Since no-one wants your advertising/job hunting here you are allowed to stay away longer!
Over 800 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
And he is known here as a shameless liar with no ethics at all.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[Guest]

If Form A and Form B aren't really link then you can design a unbound form
instead.

Steps:
1.Make a unbound form: no record source
2.Place form A and form B on to that unbound form.
3.Change code to reflect the unbound form.
a. I'm assuming you're using form reference to requery formA, so you just
need
to change your code accordingly to reflect the new setup.
4.Now form A should be completely seperate from form B. As a result when you
requery form A, you will only be requery that form.

 

[PC Datasheet]

There is some sort of connection between the record in Form A and the
records in Form B; perhaps through their recordsources. When the record
changes in Form A from the query, it causes the records to change in the
subform. This is the essence of how a mainform/subform works. If you explain
what is in the main form and what is in the subform, why you have a subform
and what processing you need to do that prevents you from linking the forms,
maybe we can help solve your problem.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)