using a form to input data into a table

S

simon

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 :))
 
P

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.
 
Top