Update fields on a table

[Nero]

Hi,
This problem seems simple but I cannot get my head around it.
I have created my own auto number routine which works fine(the reason I did this is because I was fed up of not being able to reset the inbuilt autonumber when you delete a record).When a new record is created I want to be able to add data to 2 fields in a different table which corrosponds to my new record.
So when I open up another form and find my new record the 2 fields in question have data already entered. The two tables a linked via the autonumber.
At the moment I keep getting the error message "MyForm is not open",but I don't want it open I just want up date the fields.

 

[Jack Cowley]

Try using an Update Query or an Append Query depending on whether you are adding data or modifing it.

 

[Nero]

Jack,
Thanks for your reply I will give it a go.