DISTINCT selection

[yessir]

Why won;t Form1 in this database select distinct dates?

 

[yessir]

code

code

 

[Hayley Baxter]

Are you looking to select a year in the combo and return all records for the selected year?

 

[yessir]

sort of, eventually...

what i want is to select a year,

then select names from that year

and then enter multiple entries into the pledge table



basically, i want it set up to work easily... i don't think i am on the right track for that...


any suggestions?

 

[yessir]

i guess....

i guess what i am trying to say is that i am looking for hte best way to "register someone" into the DB then be able to from there enter multiple "pledges" from that point


hence y i was trying the subform...

 

[Hayley Baxter]

Hi

I think this might be what you're looking for. Have a look at your original form FrmAidsRegistration1.

If it's not quite right let me know.

Edit: I forgot to add in the code to requery the combo, once you do that it should all be ok.

Hay