What you need is a subform control on a main form. The subform can be set to display as a datasheet (grid). Make a new form, open properties, set "default...

Hi GF:

Here is a code snippet I use to export tables. I modified for import into Access. This would be in some module within the Access app.

If vba is not...

thanks again!!

Sam

really cool!!!

thanks

I feel compelled to respond that healthcare is a wonderful place to be <g>!! Sleep is over-rated anyway.

Thanks for the help.

Sam

Neil,

I am familiar with vba on the frontend. So I don't have an XML editor.

Sam

Chris: I don't need to remember which description the user selected.

Neil: thanks! But I'm a non-techie and that is way over my head.

Well, this is the medical world and that probably explains it. Terminology can be very complex and several different words or phrases can all mean the same thing. To have...

Why? to help the user. In the real world the selection list could be very long and many different ways to list an entry that all mean the same thing...

THanks for the help. Will be working on this today!

Sam

As simple as it looks, yes, that's all I needed. I hadn't done that before and was having a brain freeze. Appreciate it!

Sam

Thanks guys!

Sam

Goce,

Are you saying something like this:

table 1

1  textHere

2  something

table 2

5  Spanish version of "textHere"

6  Spanish version of "something"

table 3 (connection table)

1  5

2  6

If so, then where/how do you tell the...

Thanks jf!

You're obviously more knowledgeable. I just got frustrated with views and found another way.

Sam

You may already be aware of this but you're running into an MS Access limitation. Pass-through queries and linked views are generally not updateable. In the MS documentation there is...