Fields not Registering

[sonoamore]

Hello all!



So in my database I have a table with a few fields (let's say, A,B,C,D,E) all text.

For some reason, only D and E are registering through VBA. Meaning, let's say I do a Me. command, I can only get D and E to work, and not A, B, or C. A,B,C don't even appear in the list.

What am I missing?

Thanks!!!!!!

[ItsMe]

Me. is not a command. It is a shortcut to include the collection name and the Object name. If you are using code in a form's class module then you can reference a control like this, Me.ControlName.

If your are typing code in the module, you can use intelisense. If you type Me. you will get some options displayed in intelisense. If you do not see your control name, look at your control properties to double check the name of the control. Look in the Other tab of the properties pane for the control.

[June7]

Where is this code - behind a form? Are you sure fields A,B,C actually included in the form's RecordSource?