Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Form is not finding the data

Geek News

Form is not finding the data
"L.A. Lawyer" <kapplaw[ at ]linkline.com> 11/29/2008 6:08:30 PM
I have a form that has a table as its source and is not filtered but shows
no data. I am able to put data into it, which is saved even thought Access
shows an error message that it is not saving the data.

I have tried deactiving all of the programming, which did not solve the
issue. I have turned allow filtering off. I have created copies of the
form and removed various controls; this also didn't help.

What am I missing?


Re: Form is not finding the data
Rick Brandt <rickbrandt2[ at ]hotmail.com> 11/29/2008 7:23:11 PM
On Sat, 29 Nov 2008 10:08:30 -0800, L.A. Lawyer wrote:

[Quoted Text]
> I have a form that has a table as its source and is not filtered but
> shows no data. I am able to put data into it, which is saved even
> thought Access shows an error message that it is not saving the data.
>
> I have tried deactiving all of the programming, which did not solve the
> issue. I have turned allow filtering off. I have created copies of the
> form and removed various controls; this also didn't help.
>
> What am I missing?

Check the DataEntry property of the form. It should be set to No.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Re: Form is not finding the data
"L.A. Lawyer" <kapplaw[ at ]linkline.com> 11/29/2008 7:45:48 PM
This works, but now I can't add or change any data. What now?

"Rick Brandt" <rickbrandt2[ at ]hotmail.com> wrote in message
news:zEgYk.8214$x%.6082[ at ]nlpi070.nbdc.sbc.com...
[Quoted Text]
> On Sat, 29 Nov 2008 10:08:30 -0800, L.A. Lawyer wrote:
>
>> I have a form that has a table as its source and is not filtered but
>> shows no data. I am able to put data into it, which is saved even
>> thought Access shows an error message that it is not saving the data.
>>
>> I have tried deactiving all of the programming, which did not solve the
>> issue. I have turned allow filtering off. I have created copies of the
>> form and removed various controls; this also didn't help.
>>
>> What am I missing?
>
> Check the DataEntry property of the form. It should be set to No.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net