Search results

Hi all, When my form opens it seems the record becomes dirty before any data is entered, and I can't figure out which field is the culprit. Is there some way to print the currently dirty record to the screen so I can figure out what's going on? Thanks!

OK, apparently it happens when after I apply the filter I get no results - but Access thinks I'm making a new record and complains about how it can't resolve the foreign keys. This is really annoying.

I'm getting an error I can't figure out. My form allows me to apply a filter once (via code), but if I try to do it again when a combo box value changes it complains with an error, saying "The ApplyFilter action was canceled" Anybody encountered this error before?

I'm filtering records based on what's in a combo box, and in the nav bar it shows "record x of 1 (filtered)". I want to get rid of the nav bar, but put the number of filtered records in a text box. Anyone know how to get that number for a control source? Thanks!

Thanks! It works!

I've got a listbox on an Invoices form. The listbox is populated by a query that references the Invoice ID (ie. the record number) that's on the form. The control source for the listbox is blank, (has to be because I do other stuff with the data in the box). When I click the navigation button...

Actually, I finally got it to work! Only 4 hours, too! Guess I don't need help now... Thanks!

Hi all, I've been trying for hours to do something very simple, and I would love some help. I have a form to display Orders for my company (date, client, order number, order info, etc). I want to have a DateTimePicker control on the page that will automatically filter the resultset to show only...