form to edit records in A table.

Clinton Pillay

New Member
Joined
Mar 2, 2017
Messages
2
Good day.

I have A table with 5 fields, which i have populated only 2 fields with data from a .xls which i imported into the table.

Please assist, or lead me in the right direction.

I need to fill in the remaining 3 fields with data - preferably through a ms access form. I also need to periodically add new records.

Ive attempted to design a form, with a combo box. therefore bringing up the field, and filling in the rest of the fields for the record, but i did not succeed.

Please help.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Welcome to the Board!

If you go to the Table in Access, and then click on Create -> Form, it will automatically create a new Form bound to your table.
You can use this Form to both update existing records and add new records.
 
Upvote 0
Hi, yes i am aware of that. Although i struggling to use a combo box to bring up what currently in the record, and edit or "fill" in the mising data in the record.
 
Upvote 0
Cross-posted here: form to edit records in A table.

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0

Forum statistics

Threads
1,221,710
Messages
6,161,445
Members
451,706
Latest member
SMB1982

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top