B
Becky
I hope that I can explain this correctly.
I have an Access XP Database the back end is in SQL.
On Form 1 we have users enter claim information including claim number and
then click a "Loss Notice" button that opens Form 2. There we have them
enter the claim number again (same number). They fill in the additional
information needed for the claim. Then we have them click on a button that
opens a Word Merge file. In the query we use for that form we tell it to use
the data that is on Form 2 in the claim number field. Therefore, when it
pulls into word it should just pull in the info for the claim number that we
are on.
The users have reported that occasionally (not always) they will get an
Enter Parameter Value box asking for the claim number from the form. They
type the claim number and all is fine.
In all the testing I have done I have NEVER got the Parameter box. Does
anyone have an idea as to why they are getting this box occasionally? I also
asked if they saw a pattern but they have not.
ANY help would be great!
I have an Access XP Database the back end is in SQL.
On Form 1 we have users enter claim information including claim number and
then click a "Loss Notice" button that opens Form 2. There we have them
enter the claim number again (same number). They fill in the additional
information needed for the claim. Then we have them click on a button that
opens a Word Merge file. In the query we use for that form we tell it to use
the data that is on Form 2 in the claim number field. Therefore, when it
pulls into word it should just pull in the info for the claim number that we
are on.
The users have reported that occasionally (not always) they will get an
Enter Parameter Value box asking for the claim number from the form. They
type the claim number and all is fine.
In all the testing I have done I have NEVER got the Parameter box. Does
anyone have an idea as to why they are getting this box occasionally? I also
asked if they saw a pattern but they have not.
ANY help would be great!