Search results

I have created a form whereby the user can search for records by date using a drop-down list containing the values stored in my table. However, the search is only returning records entered on some dates and not others although the records clearly exist in my table. This is the VBA code used...

I have created a button that when clicked appends a record to an archive table and deletes it from my original table. However there are a number of different confirmation message boxes that appear (ie- do you want to append/ do you want to delete this record) and I want to be able to condence...

I was wondering if there is any way to change the backround colour of the buttons I've created on a form? The "Fill/Back Color" button on the properties menu is always greyed out. Does anyone know of any code that can be written at all?

Summer, you just need to create a macro with the command "maximise" then link this to the OnActivate property as Peter says.

Thanks a lot Peter, much appreciated.

What i'm doing is navigating from a main menu screen to a data entry form, and then using a button to return back to the main menu. But when I do this the form "scales down" in size. I've set the properties so that the desired forms maximise on opening which they do the first time. However...