MS Access form for adding Data

Peter B · 10-07-2005 11:05AM #1

Have created a form in MS Access 2000. Did not use the wizard because instead of just text boxes for adding text I wanted to use drop down boxes etc. Created form has all relevant fields I need however I cannot set the button to add the record into my table (same project).

Is there a shortcut way of connecting form with table without writing on_click VBA code for the command button directly and if not what is the VBA code?

Thanks

Seth Brundle · 10-07-2005 09:12PM

Open the form in form view
There should be a small black arrow on the top left of the form - click it to select your form.
Right click on it and choose properties.
Under either the data or all tabs go to the record source property.
Choose the appropriate table for the data.

Now select the first field and then in the property box choose the appropriate field from the control source option.
Repeat for each field in the form.
test it!

MS Access form for adding Data

Comments