Hi Guys,
Been knocking myself out with this,
I have 3 sheets the first Find opens a form that displays driver contact detail also has a list box, the drivers detail is selected by the combobox and works well - back to the list box soon.
the contact data sheet contains the names of the drivers.
the spare cards sheet contains a list of driver names - those that have taken a SPARE card - on loan if you like.
what I'm trying to do is when then form open at the start type in any drivers surname in the combo box - the text boxes will contain all the contact detail and the list box will have either "No drivers spare card history or contain the 7 columns as in the spare cards sheet with the relevant data in it (a drivers name may appear several times in the "Spare Card" history I need to know all the history as per the column headings.
I've tried a table, vlookup to no avail I know its simple but just cant get my head around it.
Any help would be appreciated
In my haste to upload this morning I uploaded the wrong file! sorry - again any help would be appreciated
If you do happen to have a look at the file just save it and reopen it got a few little problems to work around with a "call statement - just hav'nt had the time
Bookmarks