using a form to input data into a table

[Guest]

Hi,

i need a way of inputting data into a specific location in a table.

what type of "text" box do i need in the form ?

and what is the code required for this ?

many thanks, helpful replies to the previous post )

 

[Joseph Meehan]

Hi,

i need a way of inputting data into a specific location in a table.

what type of "text" box do i need in the form ?

and what is the code required for this ?

many thanks, helpful replies to the previous post )

Take a look at the WestWind example that comes with Access. It has more
than one form used to input data.

To answer your questions we need to know a lot more about what you want
to do. Tell us about the design of the table. Do you want to only add data
or do you want to be able to edit is as well. What kind of data, what kind
of users will be entering data. etc.

 

[Pat Hartman \(MVP\)]

If you select a table or query from the combo at the bottom of the new form
dialog, the form you create will be bound to that datasource. You can
choose columns from the Fields List and drag them onto the form if you start
with a blank form or you can use one of the wizards to create a form with
all the fields from the recordsource you selected.

This is called a BOUND form. Access automatically controls reading,
writing, saving, etc. for bound forms so you don't need any code at all.
Unbound forms are a different story. If you don't know VBA, unbound forms
are way over your head because with an unbound form, you are the one who
needs to supply all the reading, writing, scrolling, saving, etc. code that
is embedded in the functionality of a bound form.