Auto Fill text command button

[bacardi451]

I have built a database in access 2000. I have a form with a subform.
The subform is for logging information. It has Date, Time, and a Memo box where a member buts in there text. Is there a way to put a command button on the form and have a certain text behind it, so when a member clicks the button it but the text on the memo box.
example "Assumed the watch"
When a person selects the button it automatically buts it in the memo box in the subform.

the reason being is that i have about 10 entry that are the same and members are too lazy to type it in all the time

Thanks in advance
Al

 

[Jack Cowley]

If you have only 10 or so possible entries then you should use a lookup table instead. Create a table with two fields, ID (Autonumber) and Task (Text). Add the Assumed the Watch, Relieved OD, etc. to the table. Now make the field a combo box and let the user select the text and the corresponding ID will be saved in your table.

If the user will be adding other information then you will have to leave your field as it is and then use code in the After Update event of a combo box on the main form to add the selected words. You will still need the lookup table for the combo box but you can eliminate the ID field. Code similar to this in the After Update event should do the trick...

[Forms]![FormName]![SubformControlName].Form![ControlOnSubform) = Me.ComboBoxName.

hth,
Jack