rowsource property not there

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
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.
 
Back
Top