I have run into a bit of a dilemma. Usually, I avoid using forms with fields that are bound to fields in a table. I started off with using VBA to create a record, insert a UserID and StatusID, then returen the primary key into a form field called REQID. That would happen in the background.
Then the user would fill in the rest of the fields that were date, double, and text datatypes. I was running an UPDATE query to update the recenty created record, with the new entered info. However, this form now needs to be used globally (around the world) - new requirement. I have been fighting with the European date and number formats for a week. The only thing that works in both US and Euro environments is to just make the fields bound to the table. (Which I don't want to do - but don't have time to fight it. - I am over deadline now.)
So, that is the back story. This is what I am looking to do now. After the user enters the request information and hits the Save button, VBA runs a check to make sure the fields are entered in the correct format and are not null. The fields are now assigned to fields within the table. But when I run the code to save, the data does not save into the table.
I don't feel that this impossible. I am just a bit overwhelmed with the constant return of failure.