Entering and Editing Data in Form View

[Guest]

I have created a form (fields from two tables) for the purpose of entering
new records and editing existing records. After creating the form, these two
functions of entering and editing are not working. I have checked the form
properties to make sure the "Yes" is present for these functions. But to no
avail. The new record button at the bottom of the form (the "arrow and star"
button) is not highlighted to indicate it being active. When I try to edit a
field in an existing record, nothing happens other than receiving a bleep
sound from the computer.

What is preventing me from doing these two functions in form view? I am
able to add/edit records in the table view.

 

[Guest]

Is the Recordsource for the form a Query?
If you are including records from more than one table in your form, it
either has to be a query or one of the table's records has to be in a sub
form. In most cases, you will need a sub form because it is very easy to
create an "Uneditable" recordset. That is a query that because of the way it
is written, no changes can be made. It is very easy to create an uneditable
recordset.

You probably need to use a sub form.

 

[Guest]

Thank you for your response.

The recordsource for the form is fields from two separate tables. (e.g.,
customer contact information, customers' order log tables).

I tried creating a sub-form with the main form. Unfortunately, the sub-form
consistently is showing in datasheet view and never in form view (even though
the main form is in form view). How can synch where the main form and
sub-form use the same view option at the same time?

 

[Guest]

Set the Default View property of the form that is being used as the sub form
to single form.