Form design wizard won't separate fields from form and subform

I have two tables that have a 1-to-many relationship. When I went through the
form wizard to design my main form, I got to the step that shows the fields
from the "one" side in the main box and the fields from the "many" side in
the subform box.

I am doing the same again but this time I have inserted the fields I want
from each table into a query and filtered the records that I would like. When
I go through the form wizard again, for some reason it won't separate the
fields from the two tables into a form and subform. The wizard produces one
form and the records from the "one" table are replicating as many times as
there are records for the respective "many" table.

I hope this makes sense amd someone understands this query. What could be
wrong.

cheers

Since you have one query, the wizard is assuming this will be a single record
source. A form and it's subform have different record sets. You need a
query for each table.

"scubadiver" wrote:

I have two tables that have a 1-to-many relationship. When I went through the
form wizard to design my main form, I got to the step that shows the fields
from the "one" side in the main box and the fields from the "many" side in
the subform box.

I am doing the same again but this time I have inserted the fields I want
from each table into a query and filtered the records that I would like. When
I go through the form wizard again, for some reason it won't separate the
fields from the two tables into a form and subform. The wizard produces one
form and the records from the "one" table are replicating as many times as
there are records for the respective "many" table.

I hope this makes sense amd someone understands this query. What could be
wrong.

cheers

Guess what? that has just occurred to me. duh!

"Klatuu" wrote:

Since you have one query, the wizard is assuming this will be a single record
source.

Them wizards aint as smart as they make out to be, is they?

"scubadiver" wrote:

Guess what? that has just occurred to me. duh!

"Klatuu" wrote:

Since you have one query, the wizard is assuming this will be a single record
source.

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.

Where in the form do you have it?

"scubadiver" wrote:

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.

The restriction is in the query. Do I have to put it in the form instead?
Whereabouts would it go?

"Klatuu" wrote:

Where in the form do you have it?

"scubadiver" wrote:

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.

it should be okay in the query. Are you saying when you run the query by
itself it works, but when you use it a a record source it does not work?

"scubadiver" wrote:

The restriction is in the query. Do I have to put it in the form instead?
Whereabouts would it go?

"Klatuu" wrote:

Where in the form do you have it?

"scubadiver" wrote:

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.

that is correct. I have the records I want in the query but in the form I get
every record for every employee!

"Klatuu" wrote:

it should be okay in the query. Are you saying when you run the query by
itself it works, but when you use it a a record source it does not work?

"scubadiver" wrote:

The restriction is in the query. Do I have to put it in the form instead?
Whereabouts would it go?

"Klatuu" wrote:

Where in the form do you have it?

"scubadiver" wrote:

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.

Do you have the Link fields set properly in the subform control?

"scubadiver" wrote:

that is correct. I have the records I want in the query but in the form I get
every record for every employee!

"Klatuu" wrote:

it should be okay in the query. Are you saying when you run the query by
itself it works, but when you use it a a record source it does not work?

"scubadiver" wrote:

The restriction is in the query. Do I have to put it in the form instead?
Whereabouts would it go?

"Klatuu" wrote:

Where in the form do you have it?

"scubadiver" wrote:

I am halfway there.

I do have another problem. In the query I have the following restriction on
the date:

=DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date())

It works ok in the query, but in the form it is still producing a record for
every week.