rowsource property not there

[Charlie]

I have a form where I dynamically change the RowSource property of a combo
box,

I've done this before many times but it's not working on my new form, all
the intellisense brings up is the .Value property. If I specify the
Rowsource property anyway: "property not found"

I get the same thing whether it's in form view or datasheet view, I'd like
to do this in datasheet view if possible.

p.s.
Access 2003

 

[Allen Browne]

The Name of your combo is not the same as the name of the field it is bound
to (its ControlSource). The *field* has a Value property, but the *combo*
has a RowSource.

If that is not the issue, then Access has become confused between these two
objects (the AccessField and the ComboBox), and the culprit is probably Name
AutoCorrect. To fix it:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact

3. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.