Forms and queries

[Guest]

I have a form with two subforms which are showing me the result of my
calculations.
subform 1 = yearly payment (the subform has always only one line)
subform 2 = Halfyear payment structute (this subform has always two lines)

I am using the form to write an offer (It's working perfect, but on the
offer the client sees the yearly payment and the halfyear payment structure).

I want to use the same queries to write the bill (on the bill should be
either the yearly payment or the halfyear payment)
So, I created two checkboxes Yes/No
One for yearly payment and one for halfyearpayment.

If I check for yearly payment, everything is perfect.
If I check for halfyear payment the query is not taking it (The checkboxes
in the query are not checked - I believe because there are two lines)

Does anyone have an idea how to solve that problem?
Thanks
Klaus

 

[Larry Linson]

You need to provide precise, concise detail of what you have and what you
are doing. Just for the record, "Queries" don't "write"... they retrieve or
manipulate data that is maintained in tables. "Forms" display to the screen
and accept input, but can be printed, though you probably don't want to
print forms; "Reports" can be previewed on-screen, but are primarily
intended for printing to hard copy (reports have additional capability in
the latest release of Access).

Larry Linson
Microsoft Access MVP

 

[Guest]

OK,
I have a table called "offer table" where I input the products, the units
and the discount for the product.
Our customers have the possibility to pay either yearly or per halfyear.
So-with I split my offer in two queries. One query for yearly payment and
the other query for halfyearpayment.

The client will accept one of them and I send him a bill.

So, I would like to use the same "offer table" where there are to checkboxes
: one for yearly and one for half yearpayment.
If I check the yearly payment checkbox the data of the table and the data of
the yearly query will create the report. (This is working).
Now, if I check the halfyear checkbox, nothing happens - It is checked in
the table but does not connect to the data in the halfyearquery.

I hope this explained it better.
I would be very thankful for any help.
Klaus