Add Record Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I seem to have half solved my problem - see post below 'Not in Recordset
Error'

I no longer get the error message when I add a New record but the problem is
in the ContractID field. As this is the PK to the Contracts table it is set
to an autonumber format but when I click the add new record button it
defaults to the number 1 thus not allowing me to enter the new record.

Please please help I am losing my head here...!!

Thanks
 
Hi

I seem to have half solved my problem - see post below 'Not in Recordset
Error'
Click to expand...

I'm sorry, "below" is sort of meaningless here. There are many
thousands of posts in this newsgroup; I'd have to go to Google Groups
and search for it, and as an unpaid volunteer that's more than I have
time (or willingness) to do.
I no longer get the error message when I add a New record but the problem is
in the ContractID field. As this is the PK to the Contracts table it is set
to an autonumber format but when I click the add new record button it
defaults to the number 1 thus not allowing me to enter the new record.
Click to expand...

Please post your code.... *in this thread*, as a reply, with the same
subject line.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top