Inputting data in a table through a Form

[Payal Patel]

Hi,
I'm trying to create a form that does the following:
I have a table that has a date, and branch number and 4 fields that are empty. I would like to have a form that has a drop down of the branch and date. How do I populate the other 4 fields in the table through the form? Ideally I would like to pick the branch and add information to the table. I know this is so simple but I can't figure it out .

Thanks,
Payal

 

[Mr. B]

The simple answer is that you make your table to be the record source for your table and each control is linked to a field in the table.

You can use the wizard in Access to create a basic form that is linked to your table.

You will then need to create the combo box where you can make a selection for the Branch. a list of the branched or you can use a hard coded list by selecting "Value List" as the Source type and then type in the values you want to be there. Again, you can use the wizard to create your combo box.

For you combo box you will need a table that has The date field can be filled in automatically by making the default value for the field to be today's date. Just go to the Default property of the field and type in Date().