Hello,
Thanks for the help once again. The code worked
well, and I was able to adapt it a little for the modules
of the other fields. Thanks for all the help and advice!
-----Original Message-----
anonymous,

1 - How about a name? Even if it's just a "newsgroup"
name. It's hard to
tell all of the "anonymous"s apart.

2 - You didn't really say. Did you finally get it
working?

3 - You weren't a "bother." Just an annoyance. :-)

To help us help you in the futu

1 - Try to use the right group. This was more of a code
with a form problem.
The "microsoft.public.access.formscoding" group might
have been a better
group than "tablesdesign."

2 - Be straight with your experience and what you need.
It's OK to not know
things. It is not OK to hide it.

3 - Unless you've taken other database and programming
classes, having just
started using Access a week ago, I suspect that you're
not really ready to
be working with code.

4 - To be honest, this explains why you're breaking
basic design rules with
your "combined" field in the first place.

5 - My recommendation on the book was based on a bad
assumption. I
incorrectly assumed that because you were venturing into
code, that you had
a *very* solid understanding of databases and Access.
Based on only using
Access for a week, you should probably start with some
more basic books.
Take a look at "Database Design for Mere Mortals" by
Michael Hernandez and
"Microsoft Office Access 2003 Inside Out" by John
Viescas. After you get a
solid Access foundation, then start looking into code.

Good luck anonymous.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP,
MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion
picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


"anonymous" wrote
in message
...
Hello Sco and Tina,
Thank you both for all your help! I'm
really sorry I didn't understand what you were saying
the
first time around and ended up bothering the both of
you
so much. I just began using Access last week, and I
had't
learnt enough to utilize your advice. I apologize for
all
the trouble and I will get "Beginning Access Book" you
recommended. Once again, I really appreciate all the
help
you've given me and I'm sorry to have bothered you so
much!




.