Creating record in sub form

L

Les

I use the code below to create a new record in a sub
[Project_Grades_Required] form when I create a new record in the main form.
this works fine. My problem is if I want to add a further record to the sub
form I get the message "A problem occured while the {Database name quoted}
was communicating with the OLE server or ActiveX Control. When I click OK
the record is created.

Can someone tell me whats happening here and how to get arround it please.

Les

strsql = "INSERT INTO tblProject_Grades_Required (Link)" _
& "VALUES(" & Me!Link_Number & ")"

CurrentDb.Execute strsql, dbFailOnError

Form![Project Grades Required].Requery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Duplicate record in Form and Subform 0
Can't seem to retrieve primary key number of newly created record in VB 1
VBA works in orignal but fails in copy of database 1
Bookmark not working on subform 5
Copy Master and Sub record to an exisiting record with specified P 15
combobox, NotInList, update form 5
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top