Form in Add mode with ODBC Table?

  • Thread starter Thread starter Abbey Normal
  • Start date Start date
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,
 
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.
 
Back
Top