How do I enter data into a table from a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I extremely new to Access, so any help would be much appreciated!

Now I have a table that I would like to make a form for other people to
enter data.

I have already created a form that includes all of the boxes that I need -
all will be combo boxes - and created 2 sychronized combo boxes that work.
But I can't figure out how to get the form to update my table.
It it helps, my form has data boxes Name, dboClusterselect,
dboProductselect, Office, and Fiscal Year. I would like the new records to
update the table "Staff."

Right now they are unbound boxes, but I'm not sure how to bind them without
screwing up the sychronized combo boxes.

Thanks for any help you can give me!
 
1. Open the form in design view.

2. Open the Properties box (View menu.)

3. Be sure the Title of the Properties box reads "Form", so you are setting
the properties of the form, not those of a control.

4. On the Data tab of the Properties box, set
Record Source: Staff

5. Select the first combo. On the Data tab, the Control Source property
should now offer a list of fields from the Staff table. Choose the
appropriate field.

6. Repeat step 5 for the other controls you want bound.

Before you do that, consider renaming your Name field. Almost every object
in Access has a Name property, so Access will get confused between the Name
of your form and the field or control called Name.

And before you rename your field, make sure the Name AutoCorrect boxes are
unchecked under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
 
I extremely new to Access, so any help would be much appreciated!

Now I have a table that I would like to make a form for other people to
enter data.

I have already created a form that includes all of the boxes that I need -
all will be combo boxes - and created 2 sychronized combo boxes that work.
But I can't figure out how to get the form to update my table.
It it helps, my form has data boxes Name, dboClusterselect,
dboProductselect, Office, and Fiscal Year. I would like the new records to
update the table "Staff."

Right now they are unbound boxes, but I'm not sure how to bind them without
screwing up the sychronized combo boxes.

Thanks for any help you can give me!
Click to expand...

They either need to be bound (which, if you've written the
synchronization code correctly, should be perfectly practical) or
you'll need to write some (some what complex) VBA code to open a
Recordset based on the table and explicitly update the table fields
with the form control values.

Why do you feel that binding them will affect the synchronization? How
are you doing the synch?

John W. Vinson[MVP]
 
Back
Top