Search results

Hi! I´m using a Combobox with an AfterUpdate event to bring up a query with the selected criteria as a filter. I´m getting blank forms when the selected criteria leaves no records. I tried using: Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then...

Hi! I've been trying to use the suggested code but in my particular case it doesn't do the trick. I'm using a combo box that when changed opens a new form with filtered results using the data selected in the combobox. To do this I use this code: Private Sub cboSearch_Change()...

Hi! I've been trying to use the suggested code but in my particular case it doesn't do the trick. I'm using a combo box that when changed opens a new form with filtered results using the data selected in the combobox. To do this I use this code: Private Sub cboSearch_Change()...

Update on the books database Hello again! I've been trying out a lot of different ways of making the form work. It's nearly complete. I've got most of the main form working. However, for some reason while browsing through the records, the SubCategory and SubSubCategory comboboxes appear blank...

Hi! I'm currently developing a restaurant project, and I'm running into the same trouble you did. How did you solve it? I'd highly appreciate a sample db! thanks!!

Rural Guy: You seem to be the only guy in all forums I've searched who's been able to answer clearly how to use categories/subcategories. I'm very new to Access and its logic. I'm making a library database for a non-profit, non-govmnt organization. I took the file you posted and simply added a...