Recent content by PTRACER

I've somehow got rid of the error, but it's actually doing exactly the same as before (Not creating a new record with what I typed previously)

Right, something is breaking somewhere, it's throwing an error code at me. It says it can't open the new form because of this line: " DoCmd.OpenForm "Products", , , , acFormAdd, acDialog, ProductCode"

Apologies, where does the FormOpen method go? Oh is that in the "On Open" section of the form properties of the form that opens up?

I have a form on my database that I use for invoicing. It has a [ProductCode] combobox where I type in my product codes and when the correct one is selected, it populates the other fields (e.g. Product Description, Price etc.) If I want to add a new product, I type directly into the...

I solved the problem myself through trying things at random. In two years, this has never worked properly and now it does! I added DoCmd.RunCommand acCmdRefresh to the end of the New Repair button. So on a new record, I guess it refreshes like I needed it to and with the Me.Refresh "On Current"...

Sorry, you've lost me...The way the database is supposed to work is that one customer owns many computers, and one computer will have many repairs. One computer will have one owner, one repair will have one customer and one computer. Is that not the same as what you refer to in your second...

I've uploaded a blank copy of my database, with a few dummy records put in to play with. The main problem is getting the Manufacturer combo box to display properly on the Repair form. I have tried all kinds of things and I just cannot get it working, I think there is something fundamentally...

Hate to be a pain in the backside, but I backed up the database, closed it, made a copy, deleted all the records, put some dummy data in and your code fix works after all :) I don't know why it didn't initially. Many thanks for your help, you have made things so much easier for me! :)

I would, but it's got a couple of hundred customers' names and addresses in it.

Product code. Which might be something like MSW7PRE-C.

Row Source: SELECT Products.ProductID, Products.ProductCode FROM Products ORDER BY Products.ProductCode; Column Count: 2 Bound Column: 1 Column Widths: 0cm;5cm If I just select ProductCode in the Query, it displays the ID for some reason, so I have to have the ID and the ProductCode selected...

That's sorted, now I need to somehow force the combobox in the Invoice form to refresh on its own as I still have to delete the text (else it still says it's not in the list if I click off of it), click off of it or press Enter to accept the entry, retype it and then it's there.

The Invoice form stays open all the time, the Products form opens and closes separately. I added Response = acDataErrAdded to AfterUpdate() but it didn't do anything.

Hi all, I have a form for entering products into an invoice, I have a datasheet and I start typing the product code in the box and if it exists in the database, it autocompletes the field, then populates the other columns with the product description, price, etc. If the product code doesn't...

To be honest, I don't COMPLETELY understand what a cascade update will do. I don't want that box checked, no?