Adding a record...

[Greyowlsl]

Hi,

I have a form that has a list of textboxes linked to table properties, and a subform linked to the same table. I used the command button wizard to create an add record command, but when i click on it it comes up with:

You cant go to the specified record
You may be at the end of a record set

i have checked the properties on the forms and querys and set all data entry to yes
What should i do?

Thanks for your time

,Leon

 

[ansentry]

If you want a form and subform then you should have 2 tables.

Have a look HERE at a sample I posted it is a Main Form /SubForm.

If it does not answer you problem then post a sample of your db and someone will have a look.

 

[Greyowlsl]

Hi,

I have access 97 so your dd didnt work. I dont understand what you mean with the two tables, but i have my database here if you want to take a look. There are still a few problems with the queries and so on that i have to figure out too but yea.

View attachment TheDD97.zip

Thanks for your time,

Leon

 

[RuralGuy]

Leon,
I think it is time to explain what you are trying to achieve with TheForm. The Text2 query I created is *not* updateable and so there is no way to go to a new record which is why you get the error when you push the button.

 

[Greyowlsl]

Ok well basicly i want it so that when i select a record in the datasubform it will show all the edits made to that document on the log form, this is to keep the user updated on the document they are looking for.

Example: I select a record from the datasubform and that record has a document number called 'F14', now that the document is selected a list of all the changes made to the F14 document are displayed on the log subform.

On the other tabs you can add a document to the drawings table and on the edit table you can add a changes record for that document to the log table.

 

[ansentry]

I have made a sample, drawing is the main form and log is the subform.

When you open it you may find a missing reference, open you form in design view and then use Alt+F11 / Tool /References and fix the missing reference.

Do you mind me asking what is the purpose of the db (it looks like document management)?

 

[Greyowlsl]

Yes it is a Document Managment Database.

The dd you created is exactly what i need, but there is an error when i select a document from the document lookup box.
Its a Complie Error - Method or data member not found and it highlights the RecordSet.Clone section of code.

Thanks

 

[Greyowlsl]

wait no i figured it out, just needed to have Recordsetclone insted of recordset.clone

 

[Greyowlsl]

Now all i have to do is make a add and edit tabs which should simple now the main problem is out of the way.

thanks again.

 

[ansentry]

Glad it worked for you.