Shared DB error with combobox on form

[Nade85]

I've got a DB that I am passing off ownership to a team. The file seems to work fine from one of their computers and the share drive location it will ultimately rest in. The problem arises from using a combobox on a form in the DB. When they go to enter into the combobox it pops up after every key stroke asking for a parameter entry. The VB and settings all match with mine but my version of the file doesn't do this. The drop down on my machine simply wittles down the list of possible entries as I type (as expected). It has been for the year and a half I've been using it. Something has clearly changed in the transfer or with their settings on their PC or software. Only catch there is that we all run on monitored and controlled machines that are meticulously controlled by a higher power. We pawns have no control over settings so there should be no differnce there.



I'm happy to provide anything I can on request. Looking for any ideas at this point.

[Gicu]

Open the form in design view ant look at the row source of the combo to see if it expects a parameter.

Cheers,

[Micron]

Is everyone mapped to the same drive letter (e.g. F:\ )
What is the parameter being asked for?

[Nade85]

Open the form in design view ant look at the row source of the combo to see if it expects a parameter.

Cheers,

It has always worked for me (on my PC) with the below row source. There are no differences on the other PCs yet we end up with it asking for a parameter that matches the tblRef_UIC_Details.UIC_Name.

Row Source:
SELECT tblRef_UIC_Details.UIC FROM tblRef_UIC_Details WHERE (((tblRef_UIC_Details.UIC_Name) LIKE '*Group 1*')) ORDER BY tblRef_UIC_Details.UIC;

[Nade85]

Is everyone mapped to the same drive letter (e.g. F:\ )
What is the parameter being asked for?

Yes, everything is mapped to the same drive letter.

[ArviLaanemets]

Exists there a Change event for this combobox in Access DB/frontend - the one users(s) having this problem is/are using?

[Nade85]

Yes, the VB coding behind everything is intact and exactly as it is on my version.

[Gicu]

Can you please post any code associated with the combo's events? And could you try this updated row source, I don't think you need to include the table name with the field names:
SELECT UIC FROM tblRef_UIC_Details WHERE UIC_Name LIKE '*Group 1*' ORDER BY UIC;

Cheers,

[Nade85]

Can you please post any code associated with the combo's events? And could you try this updated row source, I don't think you need to include the table name with the field names:
SELECT UIC FROM tblRef_UIC_Details WHERE UIC_Name LIKE '*Group 1*' ORDER BY UIC;

Cheers,

The exclusion of the table names did not yield any different results.

Purely by chance this morning, problem has been resolved. One of the team taking over the document (on their 40th scrub of it) found where the referenced table column name UIC_Name was changed to UIC Name (no underscore). No clue when or why it was changed or even what the original format was. At this point too many hands in the pot. Appreciate everybody's head scratching.