Search results

I have made some queries in which there is a field which uses the Sum function. I want to make a form which has text boxes in it, each of which shows this sum (the results of the sum). I don't know how to build expressions. If I create a form using design view, and make text boxes, I go to the...

Hello, it's me again, Forum People. What I want to do is click on a button in an existing form which shows one record at a time, and another form opens that relates to that particular record. The current form has a subform in a one to many relationship. How do I do this? Mrs Miggins

How do I make sure that for every record entered, a certain field automatically has a number 1 in it? I thought that it might be that you set the Default Value to 1 by typing "1" in the bit where it says "Default Value" at the bottom of the page. But this doesn't seem to work. :o

I have a subform which is a straightforward subform, an inventory of items, the main form of which is the location of this list of items. I want the subform to show all but one sort of item, located in the "ProductType" field. That item is called "Delivery" and is linked to a lookup table, the...

Dear List, I've made a subform which is based on a query. One of the fields from this "Many" table is "Product Type", and the query asks to list all the product types except "Delivery" (in other words, 'not "Delivery"'). I don't want to see the Delivery items in this list. The trouble is, the...

Dear List, I have made a database of locations. Each location has a subform which lists the "products" at this location. There are only about 5 sorts of product, and these are in a look-up table. I would like to add the price of these products, so that when I open a different form/report, I...