DAO - Multiple choice list box

[kharder]

Hello,

I am not new to Access, but I am a VBA and DAO newbei.

I am designing a journal database, where I would like my users to be able to create multiple rows in a table from a form with multiselect listboxes.

I will try to explain...

We help people with legal and economic advices (volunteer work). Our journal system have not yet reached the digital age, and I would like to have our clients data in a database.

One of the things we need, is to create budgets for clients. My idea is to use a form where we have some fields and a listbox, where we can choose ex. income or expence and one where we can choose the months. This will make os able to follow the process of the client.

The form:
A field where we input the description.
A listbox where we choose if it is an income or an expence.
A listbox where we choose the months.
A field where we input the amount.

Then we click a button and the table budget is updated with the information. The table budget will also contain a client id and a date, so we are able to distinguish the budgets from each other.

I have been searching the web for information on how to achieve this, but I have not yet found a good description. Only a bounch of examples, with no explanation.

Can some of you guide me to where I could find this information?

Thanks in advance...

 

[SpentGeezer]

Slightly different approach, but should do the trick....Enjoy!

 

[SpentGeezer]

To guide you through it: Just check the source code behind the "Process" button...

Client ID can be entered manually in another text box, or you can have a table of client names and numbers and use a combobox for the user to select it. The date can be added by using the VBA Date function.

Hope this helps get you started

 

[kharder]

Thank you... I will take a look at it.

 

[kharder]

This will do the trick and will definitely get me started.

Thank you...