Hi Arvin, thanks for coming back to me, it is much appreciated.

I don't think that I need the generic NotinList code, I have that. I think I
need to understand if the NotinList code will add a new record to the Table
or of it will modify the Drop Down List only. Forgive me pleas, I get
confused when dealing with Tables and Forms.
Thanks RayC


"Arvin Meyer [MVP]" wrote:

If you're looking for generic NotInList code:

http://www.datastrat.com/Code/NotInListCode.txt

or a demo of that code is at:

http://accessmvp.com/Arvin/NotInListDemo.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Ray C" wrote in message
...
Can anyone help point out what i am doing wrong Please?
I want to generata a new record and I get to that point by having the user
enter a search for a record in a Table via a combo. When the record is
Found
in the Table, no problem The user can view the Record, Edit it, etc. When
the record is not Found in the Table, the "not in List" event triggers the
question "Not Found, Do You Want To Generate"? The answer "Yes" triggers
the
Code
DoCmd.accNewRecord acForm,Me.Name,acNewRec
My Form then displays a blank series of Fields (Name Address, etc) and my
thought proccess is to just tell the program to go into my normal "Record
Edit Routine" to enter the information into the Blank Fields of what I
think
is the new Record.
HOWEVER, when I look at the Table the new record is there but the
informatiion I enter via my Edit Routine is saved in the previous Records@
Fields.

Its as though the new record is generated after I have edited the
Previouse
Record's Fields (though the previous record's information is not displayed
when I am editing what i think is the new record). Am I missing something
like "Requery" or Append or something similar to fix the New Record as
the
New Last Record?

Everything worls fine EXCEPT when I look at the table, there is a new
Record
under the name that i originally entered but any subsequent information i
entered into the blank Records are there BUT they are held in the previous
records fields.
Any Help appreciated.

Regards Ray C


.