how can i make the fields in my contact table match the ...
in [General]
|
From: mercedesb_girl on 27 Feb 2010 14:58 how can i make the fields in my CONTACTS table match the design view of my CONTACT DETAILS form? need to know asap. thanks so much for the help! i will be okay once i accomplish this. :-)
From: John W. Vinson on 27 Feb 2010 15:42
On Sat, 27 Feb 2010 11:58:02 -0800, mercedesb_girl <mercedesbgirl(a)discussions.microsoft.com> wrote: >how can i make the fields in my CONTACTS table match the design view of my >CONTACT DETAILS form? need to know asap. thanks so much for the help! > >i will be okay once i accomplish this. :-) Ummm... You can see your database. We cannot. What are your tables? Is there a Contacts table and a (one to many related perhaps) Contact Details table? or is the Contacts table bound to a form named "Contact Details"? Short lesson: A Form has a Recordsource property. This is usually a Table or (more often) a Query based on a table. On the form there are "Controls" such as textboxes, combo boxes, checkboxes, etc.; these will often have the name of a field in the Recorsource query as their "Control Source" property, binding them to the table. You might want to study up on how the program works; here are some resources to do so: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson JVinson *at* Wysard Of Info *dot* com -- John W. Vinson [MVP] |