asked on

Drop down list not showing data

I've just re-formatted my laptop and re-installed all my access files, on the forms now it does not show the list on the data however if i click on the list it will show the text data in the combo box....

it's doing this on all combo boxes and they have been correct for years....

i'm thinking it's a setting i've missed in XP or Access

Please advise

KaroBacsi

Hi!
Run the VB editor, from code or from tools Macro or Alt-F11,
Check tools references, any MISSING uncheck, and similar name check.
In main Access in tools check ActiveX.
May help you, after changes should in VB debug menu and compile your project will save changes on your laptop.
Useful if you have another PC try ran your ACCESS file, if run correctly check differences, in VB and ActiveX.
By
KaroBacsi

Benyaw

ASKER

the only differance between pc's that work with the drop down list is Office 2003 SP2 and my laptop has SP3 on it....

Benyaw

ASKER

also it's linked to my customer table, it does not show the customers on the drop down list and it doesn't show the customer on the booking form! can u recomend a way to test the customer table??

ASKER CERTIFIED SOLUTION

KaroBacsi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Benyaw

ASKER

The problem was SP3 for Office 2003, when i re-installed Office and installed SP2 it worked perfectly...
looking on EE i've seen other people report this problem with combo boxes, i think it's because i have a the format as >! to change the text to capital letters.

Regards
Benyaw