Using Data Entry Form to Populate Table

Poindexter

Registered User.
Local time
Yesterday, 23:44
Joined
Nov 14, 2008
Messages
14
I am fairly new to access and have never created data entry Forms in Access.
But so far I have created a Form with multiple combo boxes referencing various tables, text boxes for individuals information, and toggle switches for characteristic of the individuals. The Form was created for data entry purposes however; I am having difficulty linking it to a table to store the data. Is there a way to set it so that there is a table with a column linked to each text box, combo box and toggle switch, which would add a new row of data each time I entered information.
This will save large amounts time if data entry can be reduced to filling in the few text boxes and selecting from the combo boxes and toggle switches. I also believe the combo boxes and toggle switches will increase reliability so that when we are analyzing data we can pull by each of those fields.

Does anyone know if this possible or am I on the totally wrong track?
 
Last edited:
If you have already created your table, then in the properties for the controls on your form make sure that the controls are bound to the respective table fields. Thus when you enter data into the form, it will populate the table when you close the record.

Most people design their tables first and then create the forms based upon the tables. It is easier and makes much more sense.

Alan
 
To be honest I had not created a table earlier. But I have now created one, however I am not sure what the appropriate data type is for information that will be provided from a toggle switch.
Also, what I am looking for to make sure the controls are bound to the respective table fields. I am right clicking, then properties, this opens a window with 5 tabs each tab has several rows of information. None of them say bound/unbound or appear to be linked to a table, other than the combo boxes that referencing information in other tables.
 

Users who are viewing this thread

Back
Top Bottom