Form, adding information

[Certified]

Hello,

I created a form from a query. On the form, I created new text boxes where I want to insert information (Memo and Action). I want the information I entered on the two new form textboxes to be stored in the query or on a new table. Can someone tell me how can I do that?

Sorry, if I am not clear. I am new to Access.

 

[Norie]

Does the table the query is based on have Memo and Action fields?

 

[Joe4]

You cannot "store" data in a query. A query can either return the information stored in a table, or it can do calculations.

If you want the information you enter in your Form to be stored in a Table field, you can use Bound fields. Here is the easiest way to do that:
- Add the new fields you want to your Table
- Open your Query, and select those new fields to be displayed in your Query
- Open up your Form, view the available Fields, and drag those fields from that list to your Form

As long as your Form is an Updateable Form, you will now be able to enter data into it and have it stored in the underlying table.

 

[Certified]

I believe that is what I did.

I created a form with memo and action fields.

I added both fields to a query.

I then created a form based on that query.

How can I tell if my form is updateable?

Also whenever I open the form, the view is Datasheet. How can I change that?

Thanks.

You cannot "store" data in a query. A query can either return the information stored in a table, or it can do calculations.

If you want the information you enter in your Form to be stored in a Table field, you can use Bound fields. Here is the easiest way to do that:
- Add the new fields you want to your Table
- Open your Query, and select those new fields to be displayed in your Query
- Open up your Form, view the available Fields, and drag those fields from that list to your Form

As long as your Form is an Updateable Form, you will now be able to enter data into it and have it stored in the underlying table.

 

[Joe4]

I believe that is what I did.

I created a form with memo and action fields.

Not quite, unless you have a typo.
The first step is to add the fields to a Table, not a Form (speciifically, the Table that the Query uses).
If you add fields to a Form before they exist in the underlying Table, they will be Unbound (not attached to anything), unless you manually change that after the fields are created in the Table.

How can I tell if my form is updateable?

Simple way. Can you change values of bound fields, or add new records? If so, then it is updateable.

Also whenever I open the form, the view is Datasheet. How can I change that?

On the Home tab, click the View button on the far left in the menu bar, and select the View you want.

 

[Certified]

Simple way. Can you change values of bound fields, or add new records? If so, then it is updateable.

Okay, I can't add new records. What are my options? Do I have to re-create the form?

and to reiterate, that is what I did:

1. Created tables
2. Created query with data from tables
3. Created Form from query.

 

[Joe4]

Typically, if your Form isn't updateable, it is because your query isn't.
Can you edit data in your query?
What kind of query have you created?

Here is a link on a number of reasons of why a query may be unupdateable. See if any of these apply to your query:
Microsoft Access tips: Why is my query read-only?

 

[Certified]

Thanks! The link helped. I had a "stacked query." I corrected it and now I am able to edit the form.

Typically, if your Form isn't updateable, it is because your query isn't.
Can you edit data in your query?
What kind of query have you created?

Here is a link on a number of reasons of why a query may be unupdateable. See if any of these apply to your query:
Microsoft Access tips: Why is my query read-only?