Look-up table goes blank

[davedoop]

Hi all, can anyone help with this...

I have a shared database that is split into a front-end residing on about 5 local machines and a back-end residing on a central server. Occasionally the look up table that populates one of the fields on a data entry form goes blank. Oddly enough only the first column in the drop-down combo box, the ID numbers that the field is tied to, goes blank. Yet the descriptions and other columns are ok. If you try to use one of the values when it is in this state you get an error about 'not being able to assign a null value'. Shutting the front-end down and waiting a bit before starting again seems to clear the problem.

Is there some sort of sharing conflict going on? Any ideas on this will be much appreiciated.

DD

 

[willir]

davedoop

When you load a form, unless you have taken special percautions and/or implemented VBA coding, the form will populate with all records per the query or table.

Likewise, the combo boxes are also populated.

Now, if one user has a table locked, or a record locked that is used by the combo box, you will get problems. I am not sure if you can retrieve the index but not the record, or not the record and index. Regardless, you will not be able to retrieve the record(s).

If you have not done so, you will have to look at implementing multi-user shared usage strategies to avoid this type of problem.

Richard

 

[webcats]

You might want to try on the "on got focus" event of the combo box something like:

Me.refresh
or
Me.requery