Search results

Okay I recreated the combo box from scratch. The message boxes now show 768 records b4 the click and 32 after BUT it is not showing the 32 - its just an empty combo

Okay I have put two msgboxes to count the records in the cboSeats. Before the button is clicked there are 768 seats. When the dyanmic sql runs and the combo is requeried the message box outputs that there are no records. This is maddening - as when I copy the sql from the immediate window and...

Tried the requery and the same....I am making the cboSeats visible on the click event as it is hidden until the user clicks on the button. I put a break point in the code and using the immediate widow printed out the strSQL which is this SELECT tblSeats.Seat FROM tblJourney INNER JOIN...

Hi clever ones - havent dipped into access for a while and I have a problem which is probably easy to fix but my head is not straight today lol! I have four combo boxes that the user has to select (select a date a time a sitting position(window or aisle W or A) and a forwards or backwards...