u are trying to search for a particular record in a mountain of records rite?
how bout u do it by creating a text box for the user to type in what he/she wants then filter the records using the criteria the user typed in? Use the ApplyFilter function.
better explanation the combobox thats on the form with all the drivers details i want to be able to select one row by entering a suburb in a field and it finds it, or i manually choose it and it gets displayed in another box. as you can see all i can get is one field from the row displayed
well if you fix it ill owe you one
I did not have ur Excel file. ur attachment does not work without that file!!! Another thing is that, why not store all the driver's details in the same Access application? It will be much more easy to work with. Further more I am not very familiar working with Excel thru Access.
Last edited by chanjw; 04-29-04 at 09:23.
Reason: missed out details
do it something like this. I have edited and showed some example of what u might want to do. The form that I have edited is the bookings form. U should be opening Form1. I have also slightly edited ur Table1. One more thing, ApplyFilter is a function, not a button.
the test1, test2, and test3 are actually the Delivery Area of ur Mini Tankers. After u have selected one of the areas, you can type in the details in the subform and save it. if u want to add more details into the combo box, u'll have to edit what goes into it. the way i did it will let the user to browse the different entry for the same delivery area.