Total Novice

[Xcarnate]

I am attempting to make an access database (obviously ) and so at this moment have 1 simple question.

i have made a form with boxes in which you can type stuff, but i would like the data entered in this boxes to be submitted to the relevant fields of a table when i click the 'Submit' button.

I had i rough guess at what i probably needed to be done:
) edit the text boxes themselves?
) apply a macro to the submit button to make it actually submit..

I should think it is quite a simple task and i am just a moron.
(so have pity )

Finally, an example cos' EVERYBODY loves examples....

I enter Mr in the one i called Title (they are not bound maybe i should do that too!). I would like to click submit and Mr is put in the 'Customers' table, under the title field.

 

[Elana]

You need to create a table to hold the data and bind the table to the form. Since you have already created the form, you need to bind the table to the form under Record Source...then go to each field and bind each to the appropriate table field under Control Source.

You don't need to have anyone "submit" the information to the table as it gets entered in the table automatically as the user fills in the form fields.


HTH
E

 

[Xcarnate]

Thanks for that. That was all i was missing, linking it to the table (a bit obvious now i think about it, but then i didn't know what to look for). That has now allowed me to continue work on the database.

Unfortunately, i will probably manage to get stuck (again) so
*Dramatic voice* I'll BE BACK.

Sorry