Automatically add new record, enter value, then close

[Accesser]

Hi there,

I have a main form in which I'll place a combo box or option group, and upon a user's selection, some code will open up a table or another form, add a new record, enter a value, then close---all while being transparent or invisible to a user working on the main form.

This sounds wierd, I know, but it's what I need to do. Would you happen to know how to approach or code this? Is it possible to auto populate an 'closed' table? Thanks much,

Eric

 

[RichD]

You could add the new record with an append query, without opening another form. However to do what you wanted you would take the following steps:

open the form
run the append query
goto last record
close the form

this will do what you want but, from a database point of view it is unneccesary all you need to do is run the append query.

HTH
Rich Lead Developer

http://www.blsoftware.co.uk