Search results

I've found that if I bind the form to the query, then it does work for just that one query. But I want the answers to many queries on the same form, eg, text box 1 = "number of paladins in chambers" box 2 = "number of paladins outside" box 3 = "number of bins too big for chambers" box 4 =...

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...

Heavens, you're right. It hadn't done it for existing records, but has for new ones! :)

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

Dunnit! Thanks for all your help. I don't know what changed, but it now works. Instead of making a subform, I made a subform sized gap and linked the simple query of the products table (including the field from the AddressID) to it. I can't really see the difference in what I have done, but it...

Sadly I do not have a zip programme. I am at work and we are not authorised to download programmes. I know I should have one as part of WindowsXP but it is missing. I'd love to send you my db with all records deleted, but it cannot be.

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've tried to do that and it doesn't work. It needs a link. I don't know how to use all the right terminology to describe why it doesn't work and I have spent 3 days on trying to get it to work. The subform has to be specific to the record shown, so just making a query of the table which is the...

It won't let me. When I try to add it to the main form as a sub form it whines that the link I selected cannot be used, and I should go back and add the missing fields. So I've gone back, used all the necessary tables in the query, and the same thing is happening. It won't allow changes or new...

It was based on a table, not a query

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...

Thanks. The blank row existed before I made the subform from a query. Before that it was just a subform, not based on a query. :)

Thank you very much for your reply. The data cannot be updated. I looked at the help. I didn't understand it. I am really struggling to find an alternative way to deal with the data. Maybe I should try the queries section.

It is already set to Yes.

I am using a lookup table for the selection of the product type. I could change it to a combo box, but I have no idea how queries work with combo boxes. :o

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...

Len, I've mostly cracked it, thanks to your help! I didn't realise I could have two fields in the Lookup Table! So now I have, it's working nicely. The last part of the puzzle is to filter out the "Delivery" product type from the subform. In other words, I want to be able to enter the Delivery...

Product = the name of the table Product Type = the field containing the lookup table of products, lets say the list is "basket, bucket, trolley, delivery" I have, since our correspondence, added a field to the Product table called "Price". How do I make it happen that when I choose "basket"...

:confused: Thanks for your reply. I don't want the price in my subform. I want the price to be invisible until I devise a report which asks for it. I also want the Delivery to be absent from the subform. I suppose there is a query which will filter out "Delivery" from the subform. This is...

Vincent Price so, I can add a new field to the Product table called Price. I shall do this now. But how do I make it so that, e.g., whenever Product Type A is entered into the subform field, then £183 always automatically pops into the data somewhere?