Form in Add mode with ODBC Table?

A

Abbey Normal

Hi there. Can anyone tell me if it is possible to open a form in add mode to
a table that is linked via ODBC connection? (DB2 database). I don't know if
I'm doing something wrong or not. I've tried data entry "yes" and I have the
fields bound to the linked table. I have also tried DoCmd.GoToRecord , ,
acNewRec to no avail. Am I missing something or do I need unbound fields and
then insert after update...
Thanks,
 
R

Rick Brandt

Abbey said:
Hi there. Can anyone tell me if it is possible to open a form in add
mode to a table that is linked via ODBC connection? (DB2 database). I
don't know if I'm doing something wrong or not. I've tried data entry
"yes" and I have the fields bound to the linked table. I have also
tried DoCmd.GoToRecord , , acNewRec to no avail. Am I missing
something or do I need unbound fields and then insert after update...
Thanks,
Click to expand...

Is the link itself updateable? My guess is that it is not. Fix that and
then the form will work.
 

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

"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed" 0
ODBC upate on a linked table failed 2
Access 2007 ODBC Error Trapping 8
when does a form retrieve records? 1
Goto new record of subform and force a save using the default values ? 1
unbound fields on a form 1
Linked Tables - Do I Need DNS on end users PC? 1
Write conflict when a checkbox is changed and changed back on pop upform 4

Top