ARGH! I just wrote this out and because I didn't enter a software version I lost the lot!!!
Second time lucky...
Hi people, I may be thinking this out the wrong way but your input would be appreciated....
The first thing my users do when they want to add data is search to see if it already exists using the built in search in access.... All well and good but now I want to improve it a bit.
What I want.
1. User searches by DocName or DocNumber
2. Results are returned in a Listbox
3. User selects required record from Listbox, clicks a button and goes to that record (Not filtered, they still need to be able to browse through the other records)
4. If search returns no results, a message pops up and an option to add a new record appears.
I have item 1 (searching) sorted, it works fine...
I have item 2 pretty much sorted although I have to have the results appear in a new form as I can't get a listbox on the same form as the search to refresh/requery to show the results...
Item 3 is my first real stumbling block.... I was playing around with the openform using fields as link criteria but that filters the records to show the chosen record only. I need the users to go to the record but be able to scroll around all the other records.
I'm also having a bit of trouble rememberimg the way that I refer to a specific column in a listbox ( where = where & " AND [DocNumber] = '" + Me.Listbox.column1 + "'"
So I now think the openform with link criteria is not going to work... I looked in to GoToRecord next and as far as I can see the only options are next, last, first, new records etc....
Any ideas, or am I heading in the wrong direction totally?