If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MS Access form for adding Data

Peter B · 2005-07-10 11:05:10

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…

10-07-2005 11:05am

#1

Peter B

Registered Users, Registered Users 2 Posts: 1,086 ✭✭✭

Join Date: April 2000

Posts: 806

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

0

Comments

#2 10-07-2005 9:12pm

Seth Brundle

Moderators, Politics Moderators Posts: 41,242 Mod ✭✭✭✭

Join Date: April 2003

Posts: 40187

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!

0