Column names for customized query and merge

I want to provide users with an interface to create a custom merge
(all in Access, not Word). User will put in a set of brackets ("<>")
in a memo field and when they click the merge button it will grab the
fields listed in a tabular subform and merge it with their memo text.

I was able to retrieve the code to list the column names of a table.
I constructed the code to iterate the tabular subform rows and replace
the brackets with the row text in order.

What I need now is to able to allow the user to specify the column
they wish to lookup. Once the column is retrieved, in the next column
will be listed the corresponding value from the correct record.

----------
Example:

My name is <> from <>.
-----------

In a combo box I would select the table or query. Beneath that combo
box would be a tabular subform with a combo box and text box. Combo
box would be populated with the selected table or query's column
names. When the column name is selected, the corresponding field in
the table/query would appear in the adjacent text box.

I then have code to iterate over the set, merging them in order into
the memo text.

So in the example above the table would be selected:

tblPerson

and the column names would be selected in the tabular subform combo
box:

Name
State

and alongside the column names the text box would auto populate:

Name Jim
State Texas

Why go through this trouble? The Word merge code that I've found is
WAY too slow.

--

Christian

.

Relevant Pages

  • String Theory For Big Blokes
    ... Was the big bang really the beginning of time? ... Or did the universe exist ... The second approach, which I consider more promising, is string theory--a ... String theory grew out of a model that I wrote down in 1968 to describe the ...
    (rec.bicycles.racing)
  • Re: Midnight Restarts
    ... Created by bored physicists at some university somewhere, String Theory ... small Cheese Strings and governed by the laws of Quantum ... The unaccounted for dark matter of the universe consists of anticheese. ...
    (uk.comp.sys.mac)
  • Re: OT...Big Bang?
    ... it's the nature of information in the universe. ... I think string theory may be running out of string.) ...
    (rec.gambling.poker)
  • Re: Occums razor
    ... contractions and also string theory? ... You're comparing apples to oranges when talking of relativity to string ... it is far better to grasp the Universe as it really is than to ...
    (sci.physics.relativity)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)