Form Problems

  • Thread starter Thread starter WildArmSX
  • Start date Start date
W

WildArmSX

I have one form that uses a query to get results from a
table and i would have to say it works great :) But
ineeded to make multiple forms for other table and query's
so i desided to copy the good form and paste it with a new
name. I changed the control source to the appropreiate
Query which searh for a certain Criteria but when i run
the form it run my query and magically generates another
on that is total unrelated. When make the form from
scratch it also does the same thing. I am ver sure the
queries are fine because they are very simplitic queries.
These table were imported from excel but have no special
formating. If anyone know what this problem is please let
me know.

Many Thx,
WildArmSX
 
We're not going to be able to provide suggestions based on what you've
posted. You'll need to give us examples of the query that is giving the
right results, the query that is giving the wrong results, the structure of
your tables, and the nature of the data that are in the tables.

You state that you changed the control source from one query to another. Did
you mean recordsource? A form has the latter, but not the former; a control
has the former, but not the latter.
 
But
ineeded to make multiple forms for other table and query's
so i desided to copy the good form and paste it with a new
name. I changed the control source to the appropreiate
Query which searh for a certain Criteria but when i run
the form it run my query and magically generates another
on that is total unrelated.
Click to expand...

If Access starts generating queries for you, you'ld better look for
poltergeists!

The Control Source property applies to a *control* on a Form; the
Recordsource is the correct property for a Form. Could you post the
SQL view of the Recordsource for this form, and describe what changes?
Why should the form "run" the Query (it doesn't open a Query
datasheet, does it)?
 
Back
Top