Searching through one Column and update a bookmark when result found

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

Hello,

I designed a word template with some bookmarks and a word table with 7
cols(Prod.No, Descr, price, qty, colr, etc) .
I've also designed a userform with a list box to enable user select the
products. This listbox is populated from a products table in access.
When the user selects a product from the list, the Prod.No, Descr., and
price details are entered into the word table cells. The remaining
cols. are to be filled later.
However, want to search the table (Descr. colum) , if a certain product
is entered, then a standard text should be entered in a bookmark
("bmk_match") in the template.
Say if the user selects a product like: Dye light blue, Dye dark brown,
Plastics light blue, etc.
How can I write a macro to search through the table and when a product
with only ..light blue
description is found, then a standard text like "available once a
month" should be inserted into a bookmark("bmk_match") in the template.

Thanks
sophia
 
Hi Sophie,

It sounds as if you are working in entirely in Microsoft Word. This
newsgroup is for questions about using Microsoft Access to work with
external data. I suggest you start by looking at http://word.mvps.org
and then if necessary posting your question in the appropriate Microsoft
Word newsgroup.
 
Back
Top