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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
How do I clear a form? 0
ODBC upate on a linked table failed 2
Insert Index into a Table 1
Documents from shared model are created with design mode on 1
add mergefields to exsting word 2013 2
Access 2007 ODBC Error Trapping 8

Top