Each letter record is associated with only one query. Look at your tables
and make sure that you have a record in zstblQBFLetters that is related to
your current record in zstblQBFSource. If you don't have one then click the
New Button to create a letter record that will be related to your query.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
But there are none in the combo box, as far as I can tell there should
be at least two, I made to new ones as well, however the box was still
blank, In the related table there are 4.




Duane Hookom wrote:
You must select a letter.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...

no it is blank on both.



Duane Hookom wrote:
Did you select a letter from the combo box?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
Hiiii,me again...

it has continued to work fine, however I have two other small probs,
they also occurr on the DH_QBF database as well as mine (sorry I do
not
understand enough to fix them myself ).

1. When I click on Send to Word Merge btn and then click send, I
get
error # 53, file not found,

2. When I click on Send to Merge Report, and then try to
select(edit) a
letter, I get
Runtime error 3075, Syntax Error (missing operator) in query
expression
"ltrLTRID ="

I'm very sorry to bother you with these, just that I do need them
working, then I can also email you a copy with the outlook/email
function.

kind regards,
Iona



Duane Hookom wrote:
I expect it will continue to work.

--
Duane Hookom
MS Access MVP


"Iona" wrote in message
oups.com...
Hi, thanks I changed the options to break on unhandled errors,
that
seems to have done the trick.. I really don't understand...
however
will it keep on working like that?


Duane Hookom wrote:
I'm not sure why you are getting the error. I sometimes know
some
code
will
produce an error and use:
On Error Resume Next
This is only applied to a small section of code where I
anticipate
but
want
to ignore an error. I get unexpected error messages when I have
my
options
set to break on all errors.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
Hi Duane, before I send it to you I am encountering an error
message
when I run a search....

'run time error: 3014
Object MyQuery already exists.

so the from MyQuery appears to be either not overwriting or
deleting
on
close....

any pointers?

ps do i send you the whole db or just the relevant
forms/tables?
God
sorry I am still so new to this.
chers
Iona


Duane Hookom wrote:
Congrats! I would love to get a copy of the file. You can
compact
then
zip
it and send to
duane AT hookom DOT net


--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
Hi Duane, OMG, i've actually done it, so with it you can
use
the
query
output to send mass email, and you can select an attachment
or
a
file
to insert into the body of an email.

Sounds so simple, but argh, anyway it works, would you like
a
copy
of
the code/etc, you can probably polish it somewhat i'm sure.

kind regards
iona