Incorrect field submission to table

[Xarkath]

Hello,

I am modifying an inventory database and the first change I made was to split it. It was working fine before that but now there are some oddities that has me a little confused.

The major forms for this is an intake form to enter the inventory and a work sheet to identify the open items to be worked including the fields used to close the items.

After the split the intake form started changing a time field. To be clear on this; this is not a calculated field. The person entering the inventory manually enters the time in which the item was recieved. When the record is saved (or rather when the Add New Record button is pushed) the time field gets changed to something seemingly random.

Could this be some kind of conflict due to both forms being bound to the same table and being use simultaneously? These forms would never be used by the same user at the same time so that doesn't really make sense to me but I have no other theories. Also, why would this become an issue only after splitting the database?

Any insights on this would be appreciated.

Thanks

[ranman256]

This is VERY odd. Splitting normally wont affect the forms...everything is still there.
One fix may be: in the form set the text box format back to the date format you want.
It may help.

[hapm]

Would be nice to see some of the "random" outcomes you get for given inputs. Is the random result always the same, when giving the same input?

[Xarkath]

Thanks for the responce Ranman256. This field is and alway has been formatted as medium time.


However, the issue just evolved and because more complicated. It has also been narrowed only to users connected to the network through a remote desktop connection. Looks like I may need to go to my IT dept. for this one.

[John_G]

You split the database - do any other users have access to the BE who could be modifying the records?

Is there any VBA code on your foms which might be modifying the time field?

Having two open forms accessing the same table might cause issues if both were trying to access the same record at the same time. Do you get any error or warning messages?

John

[Xarkath]

Hi John,

The BE has not yet been locked down so I can't completely rule that out but it is highly unlikely with the staff I am working with. For the form in question there is no VBA, it is a simple split form with a button that has the Add New Record function tied to it. Very simple, very basic.

Thanks

[Xarkath]

Still unclear why the time field was being modified but I added "Requery" to the Add New Record button (putting Requry at the top) and after entering in several new records the issues seem to have been resolved. Easy fix for a perplexing issue.