Hi.
I have a simple Split DB with 2 tables and 5 data entry type forms. They are used to record test results of digital cameras. 1 main table (TestData) to hold serial numbers and test results, 1 look-up table to map error codes to error descriptions, and 5 forms. There are 5 test stations and 1 form to record the respective test results from that station. The database is split with the back end residing on a network share and the front end forms distributed to each local PC at the 5 test stations. My problem seems to be with the forms not seeing new records entered at other stations. For Example:
Station 1 enters the new cameras Serial number [SN], Model and condition into the form as a new record, saves and then the form resets and waits for the next new SN to be entered in. Then on to station 2 which has a combo-box that looks up SN in the table (TestData) and displays the record values in various text boxes on the form. Record your test result, save then on to station 3, etc, etc.
If i enter a new SN record at Station 1 and then walk to Station 2 and look-up that same SN i just entered it does not find the SN. I have to either click "Refresh" from the ribbon or i have to close the form and re open it.
This error happens in 2 ways. Either i get the usual "This item cant be found in the list", Or, i get no "not in list" error at all and the combo-box does its look-up function BUT no record data displays in the corresponding text box fields below as they should. When that happens i see the tables first record SN value (as in the first record ever in the table) flash briefly it its respective text box and then disappear. No sign of the SN value i just searched. Model and Condition values do not display either. Now , i can look in the linked table and see the new SN in the table, but the combo-box cant seem to locate it until i close the form and re open. I used the combo box wizard to have it look up the SN i need and then I used VB to then have it reset its value to "" once the record for the SN i search appears.
I have tried using re-query on the combo-box with little success. All stations are wired Ethernet, no security or traffic issues. If i select a SN value from the combo-box that's already been in the table before the form loaded i have no issues. If i type in an SN value that has just been entered in by a previous station, AFTER the the form has loaded, the Combo-box does reset to "" but no records display below in their text boxes. Again, it all goes away once i close and re open the form.
That was a lot, sorry. was trying to be as detailed as i could. I don't think this is a problem with any of my code because it all works great with existing values. I'm leaning more towards something with the database being split and the form not updating, something like that. Your help is appreciated.
Thanks,
Brick.