Continuous Form

[duckie10]

I have a continuous form where the record source is a query.

I want to keep the form, but change the record source. I want to change the record source to a table. When I do this, it does not work.

I have copied the query that worked and renamed it. I changed the fields selected in the query. When I use this renamed query, it works



Why is it working this way? I thought I could just change the record source to anything I want.

[RuralGuy]

You pretty much can change the RecordSource to whatever you want. Why change it to a table rather than another query? When you say it doesn't work with the table, what do you mean? Does it throw an error? Surely it does something.

[duckie10]

When it works with the query, the text boxes in the form are populated with the some of the fields from the tables in the query.

I have also used a query. I have selected the fields from just one table. When I use this query, the text boxes do not get populated.

[RuralGuy]

If the fields are named the same in the query as the table and your controls are bound to those fields then they should display.

[duckie10]

I'm using the Northwind 2007 database. I'm trying to change the Inventory List form.

When I use a query containing Products table, the form does not work.RuralGuyIf the fields are named the same in the query as the table and your controls are bound to those fields then they should display.

In the Inventory List form, I deleted all the text boxes except Product Name.

I created a query called qryProducts where I select the field name Product Name from the Products table

The record source in the form Inventory List is qryProducts

The Control Source for text box Product Name is Product Name

It doesn't work. Why?

[RuralGuy]

Does your form have the DataEntry property set to YES? It should be NO.

[duckie10]

What does the DataEntry property do?

[RuralGuy]

Forces the form to only show New records. Once saved you can no longer see the record just created.

[duckie10]

I still do not understand.

[RuralGuy]

If the DataEntry property is set to YES then the form will not display any old records.

[duckie10]

How does it display new records?

I have added new records to the Products table.

When the DataEntry property is set to Yes, these records do not display

[RuralGuy]

Once the *new* record is saved, it is no longer *new* so you can not see it. It basically always keeps you on a new record so you can do DataEntry.

[duckie10]

In the Northwind 2007 database, the DataEntry property is set to Yes in the form Inventory List

The Record Source for this form is a query called Inventory which made up of the Products table and 5 queries. The Products table is joined to these queries.


When the form Inventory List is opened, the text box Property Name is populated with all the records in the Products table

How is this working?

[RuralGuy]

Really good question!! The form is based on a nonupdateable query so it seems the state of the DataEntry property makes no difference. You could not add a new record in that form under any condition which is why they bring up another form when you want to add a record. Sorry but I don't have a better answer for you.