Search results

Hi all Simple problem I'm hoping someone can help with. I have a form that is populated using a query that looks up a table called tblFleet. I can search the query results using a simple search function I downloaded from this site(See previous thread). What I would like to do now is display...

Hi there Solved the problem. The bound field of the list box contained Null values and these were the results returning errors. I added a default value in the field criteria of the table and the code no longer returns errors. Thanks for the help. Regards Craig

Hi Bonekrusher Found out what you mean, I changed the bound column, as you said, default to 1 and tried changing it but it made no difference. The error message changed each time to reflect the column I had bound the list box to. Hope this makes sense. Will keep looking at other options. Craig

The list box is 'unbound', the row source is from qryFleetList. The form record source is from qryFleetList Craig

Hi all More information on my problem, both the form and the unbound list box get the information from the same query. The list box displays the "NA" value as in the table but the form does not. Not sure what this means exactly but could have some bearing on the problem. Craig

Hi all, I downloaded a search form from the forum a couple of weeks ago and I have just got around to setting it up on my database and it works really well. I have attached it below and recommend it to any others looking for a quick and simple Search function for their database. I have however...

Hi Neil, Worked perfectly, thanks for the advise, double checking and modifying the relationship propeties made all the difference. Regards Craig

Hi all I have 3 linked tables in a vehicle database. 1 keeps a record of Service Due date, 1 has the Fleet numbers and the last contains Vehicle Condition reports. They are linked by the Fleet numbers. I have a query that returns the Services due between 2 dates. What I would like is to have...

Thansk Trucktime, appreciate the advise, will advise how it goes Craig

Hi all I reread this and it was way to long. What I want to do is use a combo box to list values from a table field, when an option is selected, the rest of the fields update. Not sure what I have to do to achieve this. Any advise would be welcome. Regards Craig

Hi Colin Thank you very much, knew it would be simple, works like a dream. Craig:)

Hi there This is probably quite easy but I cannot make it work so would appreciate some help. I have a table containing vehicle information. I have 2 fields, Current Mileage and Max Mileage. I want to do a comparison of the 2 fields and should the Current Mileage be greater than the Max...