Hi Gillyr7,
There is no necessary to write the VBA. In this scenario, a simple form could works well.
Here is a demo to help you get started:
1. Create a table with fields Id, Name(Short Text), Gender( LookUp & releationship, input the value like male, female), Group( LookUp & releationship, input the value like A, B), Amount( Numbers)
2. Create a form for the table
Here is an helpful article about creating form for you learning:
Create a form in Access
Please let
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.