Please excuse the cross-newsgroup post but I'm in a bit of a time crunch.

I have a form that users use to enter data into a table. During development, all was well; it worked perfectly. When I upsized it to my local instance of SQL Server, all was well. In moving it into the production phase, I moved it up to a SQL Server and now it's behaving differently. The form now does not have an "add record button" on the record/status bar at the bottom of the form (it's there, just grayed out). What would cause this? Anyone?

I also have a command button on the form that I created to add a record (via the wizard) and it gives the error, "You can't go to the specified record." The problem is related, but I can't figure it out. The standard tool bar "add a record" button is grayed out.

I have since noticed that there is no key field in one of the upsized table. Could this be the problem/reason?
tia,
JMorrell