Search results

So..... I know this has been "dead" for awhile, but I've just come across it. I would love to have a search function kind of like this for my database. However, I'm having a few problems. I tried to emulate Query1 using my own tables and stuff, but I get an error, and I'm not sure why (I'm also...

Unfortunately I cannot have CustomerOrderID as Autonumber as it needs to relate to our other system where the orders are generated, this is merely to keep track of what went where and when kind of deal.

So, I have manged to figure out how to get my additional info copied like I wanted it to. All I had to do was look a little harder in "Properties" while in Design View of the form, with the Subform name selected (ie. CustomerOrderDetails) and just add in the additional field (ie. CompanyName)...

Did I post in the wrong spot? Am I not making sense? I would really appreciate some help here... Please let me know if something needs clarifying :)

Please bear with me. I have been playing with this for a little while, and while I feel I am almost done, there are a few little quirks that I would like dealt with.... Can I get my table associated with my subform (CustomerOrderDetails) to be filled in with the company information that is...