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

[FW Salato Center]

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.