Hi,

I need to generate an ID number which will be stored in a

table created in my database. The ID comprises 3Alpha +

3Numeric (two fields)contained in this table created.

How do I reference this table in my procedure in order to

work on the data in this table.



Thanks

Vaughn



Not sure I understand what the ID has to do with "how do I reference this

table in my procedure"?  Also not clear on just what procedure you are

describing.



Depending on what you are trying to do, using what mechanism (code module,

macro, code-behind-form, ...), you can often refer to a table by its name

(e.g., tblPerson).



--

More info, please ...



Jeff Boyce

<Access MVP>