Button to choose data type

[Brother Sharp]

Hello guys,


I am new to access.

What I want to do is to set up a button in where the value that I typed in a text box besides it, be transferred to the corresponding cell type.
Let's say I typed 100, and then I click Income or Expense, If I press Income it will be sent over to the cell containing the incomes and etc. A check box works too.

Next thing that I want is to create a sub category.
If I have a large categories list like in the personal account ledger template, I want to be able to select a main category and if it has a sub category, give me a drop down box to select the corresponding one.
I enter my value, choose whether its income or expense, date and etc, then if I choose the "Home" category, I want it to allow me to also select whether its "Phone", "Water" and so on.

any help would be appreciated.

[June7]

Enter a value then click a button? Two actions where one would work. Just enter into the Income or Expense field. Otherwise need code like:
If Me.Category = "Expense" Then
Me!Expense = Me.Amount
Else
Me!Income = Me.Amount
End If

What is the checkbox for?

This is cascading (dependent) comboboxes. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.

[Brother Sharp]

I see now,
What about the sub-categories?
I want the report to look like this:

Category Date Amount

sub-category 1 Date Amount
Sub category 2 Date Amount

Category 2 Date Amount

I have made it in the report to show all the data by category in ascending order, as in the personal account ledger sample template.
What I want to do is that when I select a main category in the form and enter a value, If I have selected a sub-category (Make it selectable if available) input the value as that sub category
So if a main category is holding 1000$, I want the two sub categories to have say, 750 and 250 respectively and show up on the above report

[June7]

Enter amounts at the subcategory level only.

I took a quick look at the template database. The way it is set up is not to select category then subcategory. When entering a transaction just select the category (Entertainment, Groceries, Wages). Each category is defined as an expense or income item. Your data structure seems to have modified this structure to have another level of categorization. Are you also putting the amount in separate columns for Expense and Income? Again, this is not like the template. Would you like to provide your project for analysis?