Search results

ooops sorry my mistake I added brackets where i didnt need any. it works fine, thank you so much Tom

when i try this it returns #Name?

Is there a way to press a button on a form to go to a new form and automatically fill in data from one form to the other? E.g. orderID in form1 then press to go to form2 and have orderID (same field) entered automatically??

ive been playing around with the requery and i've managed to do it. Thank you so much I never would have come up with that! Cheers Tom

Thanks ken, but those are both giving #Error in the product name field. The re.query doesnt seem to be doing it either! When i started this I thought it'd be simple!! Haha. Thanks for your help so far

i know where the after update event is but how do i requery?

Im just testing out this feature, im trying to enter a product id and get the product name entered in automatically into a form. I have the product name on the forms' controlsource set to =DLookUp("[ProductName]","Products","[productid]=Forms![Order Details]!ProductID") this works but only...

I have the query like u say, and that is the recordsource for the form. The purpose of the form is to add new orders, so i need to save the contactname again in the orders table so when viewing orders the contact name is in there. Phew!

yeah ive just checked and its definately bound to the right field, all other fields are saved just not this one!! Thanks

sorry i dont quite understand what u mean by control?

AutoLookUp This sounds very similiar to what ive just figured out to do. Its called AutoLookUp. I wont try and explain cos im just not that good, but if you look at Access help files and check out the internet you should find some good resources. Try...

I need some help please! I've created a query to use the AutoLookUp feature, this almost works fine and well. I have a form to add a new record. On this form the autolookup feature works, as I select the company, the contact name is automatically filled in. But on completing the record all...