Im trying to create a simple work rota, I have managed to do everything having never used access before all except for the report printing. Basically the problem I am getting is that access is prompting for the filter parameter even though it already knows it. My database primary ID is the date, I have tried filtering just using "Date()" instead of my paramter to test the report and it works for todays report, but when I substitute back my search parameter it comes up with the prompt again.
When I use this it comes up with a prompt asking for me.datebox, however if I go into debug mode and put my cursor over both me.datebox and Date1 in the code it displays the correct date from my form so I know its pulling in the date.
Im getting another prompt for value problem, I have set up a combo box with a list that works from a table "HaemBMS" I have used some code that allows you to add to this list if the name you type dosent already exist using an SQL statement for the raw source "SELECT DISTINCT NameS FROM HaemBms ORDER BY NameS"
This works fine, however I would now like to be able to delete from the list using the same combobox "BBSAM" With a double click, im using the folowing code and when I run it, it comes up with a prompt that is the name im wanting to delete from the combo box.
Private Sub BBSAM_DblClick(Cancel As Integer)
Dim strSQL As String
Dim BBSAM As String
Last question for tonight, the delete works pefect from the table however the name of the person is still displayed in the combox, I have tried the statement BBSAM.Requery but it doesnt get rid of the name even though its n0 longer in the drop down list. Any ideas how I can blank the combobox?