I read your post about the problems with creating a form before the table. You said: "First, you have to open up the FORM PROPERTIES. Double-click on the square where the two rulerbars meet. This will open up the form properties. Now set the RECORD SOURCE property to your new table. Now you've bound the table to the form.
Now you have to go to EACH CONTROL (text box, check box, etc.) on your form and set the CONTROL SOURCE property to the matching field in your table."
What else do I need to be concerned about? (field types, how does the form update the table, other issues?) Thanks for your patience and help!
Reply from Richard Rost:
Once you set the form's control source, and the control sources of all of the objects on the form, they're bound to the table. You don't have to do anything else to save records to the table. Once again, that's why it's better to build the table FIRST.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.