K
knowshowrosegrows
I have a form with a drop down that chooses the agency, program and program #
to enter data to. I have fields on that same form that show the contact
person and contact number. I have a subForm with Census Date, Census,
Admission and Discharges.
I want the user to be able to
1. Choose the program in the dropdown
2. See the name and phone of the contact person, but not change that data
3. Have Census Date automatically be today
4. Do data entry for Census, Admissions and Discharges
The drop down works great and shows the contact info. I have the main form
set to no additions and lock the contact info controls and then the user
can't change them. Unfortunately, my subform disappears as well. Then I
take off the "no additions" on the main form and just leave the controls
locked and my Census Date on the subform no longer shows "today's date;" it
has reverted to the earliest date in my tblCensusEvent even though I have the
default set to Date().
Is the problem
to enter data to. I have fields on that same form that show the contact
person and contact number. I have a subForm with Census Date, Census,
Admission and Discharges.
I want the user to be able to
1. Choose the program in the dropdown
2. See the name and phone of the contact person, but not change that data
3. Have Census Date automatically be today
4. Do data entry for Census, Admissions and Discharges
The drop down works great and shows the contact info. I have the main form
set to no additions and lock the contact info controls and then the user
can't change them. Unfortunately, my subform disappears as well. Then I
take off the "no additions" on the main form and just leave the controls
locked and my Census Date on the subform no longer shows "today's date;" it
has reverted to the earliest date in my tblCensusEvent even though I have the
default set to Date().
Is the problem