Hi!,
I've been trying for the past 3-4 days now to set up a form for data input of student records.
I need to be able to 'blank out' some of the fields so that users can't input into them accidantally or until a specific entry has been made in a previous field.
I have tried this 2 different ways so far but neither have been successful:
Method 1:
I set up a subform for the student marks (which sits inside the main form for all contact details etc). I set it up so the user would click on command buttons to display pop-up screens and input the data into these (to make it more user friendly and avoid error). This form worked fine as a stand alone form, but as soon as I put it as a sub-form and tried to use the command buttons none of them worked. I tried stating that the different form names but this didn't help.
Anyway I then decided to try doing the system another way (in true British spirit....
)
Method 2:
I set up the form as a subform, and wish to have certain fields enabled/unenabled depending on whether the User inputs "Yes/No" in a previous field. This worked when I set it up on the on-current (in the form procedures) - however this meant that it did not update the view until the User goes to the next record. I need to it update automatically (or as soon as) - I've tried changing the timer intervals to save and refresh the form at 6000 but this still doesn't change the enable/unenabled view....
I'm favouring method 2 at the moment as it just feels less messy to work with. However if anyone can help me with either method - I'd be really grateful!!
Cheers,
Kate
I've been trying for the past 3-4 days now to set up a form for data input of student records.
I need to be able to 'blank out' some of the fields so that users can't input into them accidantally or until a specific entry has been made in a previous field.
I have tried this 2 different ways so far but neither have been successful:
Method 1:
I set up a subform for the student marks (which sits inside the main form for all contact details etc). I set it up so the user would click on command buttons to display pop-up screens and input the data into these (to make it more user friendly and avoid error). This form worked fine as a stand alone form, but as soon as I put it as a sub-form and tried to use the command buttons none of them worked. I tried stating that the different form names but this didn't help.
Anyway I then decided to try doing the system another way (in true British spirit....
)Method 2:
I set up the form as a subform, and wish to have certain fields enabled/unenabled depending on whether the User inputs "Yes/No" in a previous field. This worked when I set it up on the on-current (in the form procedures) - however this meant that it did not update the view until the User goes to the next record. I need to it update automatically (or as soon as) - I've tried changing the timer intervals to save and refresh the form at 6000 but this still doesn't change the enable/unenabled view....
I'm favouring method 2 at the moment as it just feels less messy to work with. However if anyone can help me with either method - I'd be really grateful!!
Cheers,
Kate
