Add different fields to a form

[Infinite]

Hello, I have a table Items, ItemSizes and ItemTimes. That is for my item, I also have a table tableShowCost which is
the sales I have made at shows. I created a query from all of Items, the size of the item (from table ItemSizes) and
the ItemTimes (from tableItemTimes). Then, I created form from all of that. So, now I have a form the displays all
of the information about my item. Back to the Table ShowSales, it has multiple sales of different items, I want to
know the total amount of sales I have made, so, I just did a easy query that gets me the total sales, but, I don't know
how to get this information to display on my form, nor how to link an item on the query that gets me the total of each
items sold, to the form. Any help would be appreciated, thanks!



(Should of thought of zipping it first)

Also, if some one does ask and gets the database, could they look and figure out why I cant go to the next record after opening it from the main form? thanks!

 

[Trevor G]

Try compacting the database and then zip it up to upload if the size exceeds 2MG it wont be allowed.

If that is the case then place a link to your thread to the database where every you upload it to, such as DropBox.

 

[Infinite]

So, has any one looked at it yet?

 

[JHB]

... So, now I have a form the displays all
of the information about my item. Back to the Table ShowSales, it has multiple sales of different items, I want to
know the total amount of sales I have made, so, I just did a easy query that gets me the total sales, but, I don't know
how to get this information to display on my form, nor how to link an item on the query that gets me the total of each
items sold, to the form. Any help would be appreciated, thanks!

Use the Dlookup function:
Below is a link to the description and some examples.
http://www.techonthenet.com/access/functions/domain/dlookup.php

... why I cant go to the next record after opening it from the main form? thanks!

Which form is the main form, (show a print screen of what you mean)?

 

[Infinite]

Which form is the main form, (show a print screen of what you mean)?

No, I figured out whats wrong, when I double click it brings me to that item, and its filtered for that item, I just have to figure out how to disable the filterer as soon as I double click.