Search results

Time is running out, PLEASE HELP look at the form frmAIDSYear y won't the form filter work? this is what i wish to do> select the year in frist form, should only display names and id from year selected in the next form then based on that only the subform of the walker name and id...

no.. that didn't work at all! the forms selection didn''t restrict querys select the year in frist form, should only display names and id from year selected in the next form then based on that only the subform of the walker name and id selected way to go through is frmYear > frmName >...

i have the form year going to the form name then to the form pledge. the problem is that they aren't being limited by the query... i want them to enter a year, (Also want the years to be DISTINCT and won;t be when i try) then from there go to the name form to pick a name limited to the year...

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...

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?

code code

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

but but the selectors themselves do not update each other as well the total for all the totals on the subforms here is my problem: see registration1

but but what if the number != the record nuumber?

i have multiple fields and i want them to update to the proper record if one of the fields are selected. ie: if name selected from combo, ID, Date, Job, Subform go to proper record if ID selected, goes to the others respectively ??

GOT IT! thanks for the help

here's the code SELECT [Volunteer Info2].VolunteerID, [Volunteer Info2].Name, [Volunteer Info].ComplimentaryAndTherapies, [Volunteer Info].FrontDeskCoordinator, [Volunteer Info].ReceptionFrontDesk, [Volunteer Info].ReceptionAnonTesting, [Volunteer Info].PreEventSupport, [Volunteer...

in the query i guess that the problem is in the query, although shouldn't be :confused:

here's the code code

it's the report the report doesn't know which table to get volunteerID from

how can i say this? SELECT ([Volunteer Info2].VolunteerID, *) From the problem is that the query won't recognize the VolunteerID from just the table listed above... ie i used * but there are tables linked by the ID and it won't select the right one

CODE CODE

I have this form witha subform and i wish the subform as well as hte boxes to go to the proper data when any one is selected. ie: if name selected, the date, ID, subform and the Total are all set to the proper records. This is to allow ease of data entry. also, The box at the bottom is a...

thanks again thanks

great, thankyou! I am also wondering if there is a way to reset the auto Number for table info2?