[AccessD] FW: Form changing behavior after changing record source

[Charlotte Foust]

​Is the query itself updateable?  It doesn't sound like it, and in that
case there will be no New button on the navigation controls.​  If the query
cannot be updated when you run it, there is no way to add or edit records
in a form.



Charlotte Foust
(916) 206-4336

On Thu, Mar 26, 2015 at 10:01 AM, FW Salato Center <Salato at ky.gov> wrote:

> I am still struggling with this. Here's what I've found so far.
>
> I created the query wizard to create a simple SELECT on one table. When
> viewing the query in Datasheet view, there's no New button on the
> Navigational toolbar. This seems to be why the form is ignoring the Data
> Entry property.
>
> I don't work with Access much anymore, but I don't recall ever running
> into this before. I can't figure out how to enable new records so the form
> can honor the data entry property. If someone can tell me how to do that,
> I'll probably be fine.
>
> Susan H.
>
>
> From: FW Salato Center
> Sent: Friday, March 20, 2015 1:11 PM
> To: 'accessd at databaseadvisors.com'
> Subject: Form changing behavior after changing record source
>
> Using a menu form, a button opens a form in data entry view - empty form.
> The same form is also used for browsing and editing at different times -
> clicking the button sets the properties when opening the form:
>
> DoCmd.OpenForm "Enter New Animals", acNormal,,,acFormAdd,,"New"
>
> I changed the form's resource source from a table to a query that I based
> on the table - same fields. Now, clicking the menu button to open the form
> in data entry view opens the form filled with data. I have no idea why this
> should matter. Editing and browsing mode are still working fine.
>
> Any idea why changing the record source is inhibiting
>
> Susan H.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>