Search results

In this case it will be the primary key or name (name is yet to be added) that will be searched for. I dont suppose you know how to find the a record with a certain primary key or name and then go to it, do you?

Thanks again Adam, I'm just looking how I can use this. Super helpful as ever. Will post results.

Thinking about it, yes that would work. Although im not sure how to do it. So here my new question. If i have a form which is bound to the Customer table (Shown above), and i have a 'Customer Number' Textbox which is bound to 'Cardinalis Customer Number' in the Customer Table. If the current...

Damn! Hmm, that poses a small problem. I shall have to take a different approach to this then. Thanks for everyones help.

Thank you for the quick response. I have tried your code, but don't understand where you got "[RecordID]" from. What exactly is its purpose? What i really need to do is to find the record number of a given primary key for a tuple in a table. This will allow me to set the form current record to...

>>>Sorry about that, double post<<<

I now have a new and simple (ish) problem that needs solving, however, i think it involves a fairly complex solution. I have a form as shown below. That should describe most of the basics of the form. Here is the problem: You can use the navigation buttons to successfully go through all...

Well Adam it has caused some head scratching here as decide how we want the database to work but it has certainly helped a great deal. I didn't consider using a form but as it has a VBA module to work with it certainly does have advantages. We do lose the advantage that with the method we were...

I have searched and search and I can't find the answer to this question when I thought it would be simple. Hopefully you can put me out of my misery! I have a access 2007 split form with a series of search boxes and a query result window. Enter info into one or more of the search boxes, click...