Record source problem

#1 September 3rd, 2006, 02:45 PM

Hi

I Saved As... a form to another name and change the new forms data source.
The problem is that the new form does not show any data with the new data
source. I have tried compact & repair and decompiling but no luck.
Eventually I had to put in the form load event the command
DoCmd.RunCommand (acCmdRemoveFilterSort) to make the form show any data. Why
would the form have a filter attached to it so stubbornly?

Thanks

Regards

#2 September 3rd, 2006, 02:55 PM

John wrote:

Quote:

I Saved As... a form to another name and change the new forms data
source. The problem is that the new form does not show any data with
the new data source. I have tried compact & repair and decompiling
but no luck. Eventually I had to put in the form load event the
command DoCmd.RunCommand (acCmdRemoveFilterSort) to make the form show any
data. Why would the form have a filter attached to it so stubbornly?

Does the new RecordSource have all the same field names? If not you have to
change the ControlSource property of all your controls to the new field names.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#3 September 3rd, 2006, 03:05 PM

After reassigning record source I reassigned fields as well so they are OK.
Also it works if I use the remove filter command either in vba or manually.

Regards

"Rick Brandt" <rickbrandt2@hotmail.comwrote in message
news:1bCKg.5131$tU.1958@newssvr21.news.prodigy.com ...

Quote:

John wrote:

Quote:

>I Saved As... a form to another name and change the new forms data
>source. The problem is that the new form does not show any data with
>the new data source. I have tried compact & repair and decompiling
>but no luck. Eventually I had to put in the form load event the
>command DoCmd.RunCommand (acCmdRemoveFilterSort) to make the form show
>any
>data. Why would the form have a filter attached to it so stubbornly?

>
Does the new RecordSource have all the same field names? If not you have
to change the ControlSource property of all your controls to the new field
names.
>
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
>

#4 September 3rd, 2006, 03:45 PM

John wrote:

Quote:

After reassigning record source I reassigned fields as well so they
are OK. Also it works if I use the remove filter command either in
vba or manually.

If you see records when you use "remove filter" then the reason you don't see
records is because of a filter beking applied. Most likely you have the
DataEntry property set to true.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Record source problem

Popular Articles

What is Bytes?