How do I enter data in a form that I already created?

  • Thread starter Thread starter Nirav
  • Start date Start date
N

Nirav

Hello,

I created a from and now trying to enter data but It is not allowing me to
enter data.

After creating a form, do I need to do anything so it allows to enter data?

Nirav
 
Are you sure the form is editable (has the arrow and asterisk at the bottom?)
If your table or query the form is based on is not editable, the form won't
be either. Check those first.
 
It is not editable.

I want to make it editable.

Golfinray said:
Are you sure the form is editable (has the arrow and asterisk at the bottom?)
If your table or query the form is based on is not editable, the form won't
be either. Check those first.
Click to expand...
 
Is there any way to pop up arrow and asterisk?

Golfinray said:
Are you sure the form is editable (has the arrow and asterisk at the bottom?)
If your table or query the form is based on is not editable, the form won't
be either. Check those first.
Click to expand...
 
Yes, you need to open the file as a query. Go to design view. Under QUERY,
change it to a Make-Table query. Run it and make a new table. The new table
will be editable.
 
Dear Golfinray,

For the first time when I opened access, I click on forms and then I click
on "Create a form in Design View" then I created form with text boxes and
comboboxes. Now I have only form created. My another objects such as
"Tables", "reports" or "Queries" are empty. There is only one file and that
is under "Forms".

I am planning to enter data in this one form, but I am not able to do that
as there is no arrow or asterick popped up.

Please help.

Nirav
 
Dear Golfinray,

For the first time when I opened access, I click on forms and then I click
on "Create a form in Design View" then I created form with text boxes and
comboboxes. Now I have only form created. My another objects such as
"Tables", "reports" or "Queries" are empty. There is only one file and that
is under "Forms".

I am planning to enter data in this one form, but I am not able to do that
as there is no arrow or asterick popped up.

Please help.
Click to expand...


Forms in Access are used to enter, edit, or view the data
that is stored in tables.

Think of the "controls" on forms like viewing tubes or
periscopes to the data in your tables.

Constructing tables and relationships is usually the first
step in building a database in Access.

Wiki for "normalization", and you'll be off to a good start.
 
For the first time when I opened access, I click on forms and then I click
on "Create a form in Design View" then I created form with text boxes and
comboboxes. Now I have only form created. My another objects such as
"Tables", "reports" or "Queries" are empty. There is only one file and that
is under "Forms".
Click to expand...

Nirav, a Form does not contain any data. A Form is *just a tool* - a window to
let you edit data stored in a Table. Data exists in tables, and only in
tables; you will use Queries to filter, sort, and combine data in tables,
Forms to display the data onscreen and edit it, and Reports to print it.

You may want to look at some of the tutorials and other resources available
for getting started with Access:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top