ACCESS FEED: RE: [MS_AccessPros] Display all records in subform datasheet

Minggu, 24 Juli 2011

RE: [MS_AccessPros] Display all records in subform datasheet

Deb-

Something funky is going on. Yes, a properly linked Datasheet form should show
all the rows related to the outer form record. The "Can't assign a value to
this object" message means you have a problem in the code or macro behind the
form(s). Can you copy and paste ALL the code from both the form and the subform
in a reply? When you get the error, do you see a Debug button? If so, you can
click that to see the offending line of code.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Deb
Sent: Sunday, July 24, 2011 6:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Display all records in subform datasheet

Hi John,

I have the ID's linked on the form and the sub form. There is one line that
shows in the subform when I open the form, but when I go to make an entry on
that line it tells me that I can't assign a value to this object and then it
automatically adds a new line and I can make entries. I can't find any code
that would make data entry run, although I am very new at this so it may be
something I am missing.... Am I correct in understanding that when in
datasheet the subform should show all previous entries?

Thanks!

Deb

On Sun, Jul 24, 2011 at 10:15 AM, John Viescas <john@viescas.com> wrote:

> Deb-
>
> That would be the only thing that comes to mind that would show you an
> "empty"
> subform when you reopen the outer form. Do you have your Link Master /
> Link
> Child properties of the subform control set properly? Is there any code
> running
> in either form that might put the subform in Data Entry mode?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links