Command buttons to enter database (form) fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to make a way to eliminate data entry errors by placing
command buttons on a form to automatically enter the button text into a field
and refresh the form to show this.

For instance: the field is called [Accomplishments]. I want to be able to
push a button, for instance "Appointment with job counselor," having the
"Appointment with job counselor" added to the [Accomplishments] field.

The main purpose for this is, again, to eliminate data entry errors and to
keep the list of accomplishment choices to a minimum.

Any help would be appreciated.

Thanx in advance.
 
Why not use a bound ComboBox instead. You can create a list of acceptable
values in the Row Source or better yet, create a small table with the
acceptable values, which you can read into the rowsource with a query. That
way, you can add values to the combo by simply adding values to the table.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I have been trying to make a way to eliminate data entry errors by placing
command buttons on a form to automatically enter the button text into a field
and refresh the form to show this.
Click to expand...
For instance: the field is called [Accomplishments]. I want to be able to
push a button, for instance "Appointment with job counselor," having the
"Appointment with job counselor" added to the [Accomplishments] field.

The main purpose for this is, again, to eliminate data entry errors and to
keep the list of accomplishment choices to a minimum.
Click to expand...

Umm...?

Why use command buttons and code to do precisely what the builtin Access tools
- Combo Box, Listbox, even Option Group - controls do natively?

Or are you (mistakenly, I'd suggest) storing multiple rows of data into an
Accomplishments memo field? If so, consider a one to many relationship
instead, storing each accomplishment (using a combo box!) in a separate
record, on a Subform.

John W. Vinson [MVP]
 
Well, I took the previous suggestion and worked it with this one to
accomplish what I needed. Thank you.

I suppose the only reason that I was going to use command buttons is simply
because I am dealing with a lot of computer illiterate people in here, and it
is best to spell it out for them. :D

Thanx again.

John W. Vinson said:
I have been trying to make a way to eliminate data entry errors by placing
command buttons on a form to automatically enter the button text into a field
and refresh the form to show this.
Click to expand...
For instance: the field is called [Accomplishments]. I want to be able to
push a button, for instance "Appointment with job counselor," having the
"Appointment with job counselor" added to the [Accomplishments] field.

The main purpose for this is, again, to eliminate data entry errors and to
keep the list of accomplishment choices to a minimum.
Click to expand...

Umm...?

Why use command buttons and code to do precisely what the builtin Access tools
- Combo Box, Listbox, even Option Group - controls do natively?

Or are you (mistakenly, I'd suggest) storing multiple rows of data into an
Accomplishments memo field? If so, consider a one to many relationship
instead, storing each accomplishment (using a combo box!) in a separate
record, on a Subform.

John W. Vinson [MVP]
Click to expand...
 
I suppose the only reason that I was going to use command buttons is simply
because I am dealing with a lot of computer illiterate people in here, and it
is best to spell it out for them. :D
Click to expand...

<g>

A Listbox with a label by it "Use the mouse cursor to select the line to be
entered; click on the line to enter it" might be needed...

John W. Vinson [MVP]
 
Back
Top