Hi
I have a multi-select listbox on a form which I am using as a payments made form. Basically, the form opens with the date set to a default of Now(), users can change the default date. Users then select the people who have paid and then click a command button to enter the default payment amount into payments table. Works great. (Thanks to this forum for the original code etc.)
What I am looking to do is a slight variation on this whereby if someone has already paid for the specified day, their name is not listed. Currently if someone has paid for the specified day and they are selected along with other people who have not paid, the command button does not function, ie, it doesn't make the payments into the payments table.
Any ideas would be great.
DB included.
I have a multi-select listbox on a form which I am using as a payments made form. Basically, the form opens with the date set to a default of Now(), users can change the default date. Users then select the people who have paid and then click a command button to enter the default payment amount into payments table. Works great. (Thanks to this forum for the original code etc.)
What I am looking to do is a slight variation on this whereby if someone has already paid for the specified day, their name is not listed. Currently if someone has paid for the specified day and they are selected along with other people who have not paid, the command button does not function, ie, it doesn't make the payments into the payments table.
Any ideas would be great.
DB included.
